ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how can I create a ODBC database in excel (https://www.excelbanter.com/excel-worksheet-functions/37889-how-can-i-create-odbc-database-excel.html)

Deler9

how can I create a ODBC database in excel
 
I am using Excel and am trying to create a database that will check for
duplicate field entries and/or records. Help?

Debra Dalgleish

You can use Data Validation for this. Chip Pearson has instructions on
his web site:

http://www.cpearson.com/excel/NoDupEntry.htm


Deler9 wrote:
I am using Excel and am trying to create a database that will check for
duplicate field entries and/or records. Help?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 06:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com