Transferring Data from Excel into a Database

kd3330

New Member
Joined
Apr 30, 2009
Messages
1
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!
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,102,556
Messages
5,487,535
Members
407,605
Latest member
PACULA

This Week's Hot Topics

Top