I am trying to export data from Excel and import it into a database (resultsplus!). I don't have much experience with databases (or excel) and really need help. I feel like I have set everything up right but every time I try to import the info into the database, this message pops up: "An update option has been selected, but no indexed field is in the data. Please add an indexed field or choose an 'Add Only' option." How do I index a field in Excel? Or is my problem in the database? I am trying to change all the constituency codes in the database. Please help!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Transferring Data from Excel into a Database
- Thread starter kd3330
- Start date
