importing excel spreedsheets

C

compunow

Hi,

Thanks one and all for your input. I recreated all the field names in a new
spreadsheet then cut and paste the data from the problem execel sheet.
Access accepted the field names but bulked on the data it seem like it is
having a problem because of duplicate entrys. I am getting a message with
indexing to many fields but it imported.

Any input about getting this indexing to many field names?
 
J

Joe Fallon

Not sure what you mean but Access "automatically" indexes fields if they
have certain values in their name like:
ID;key;code;num

Check Tools, Options, Tables/Queries
AutoIndex on Import/Create:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Names in Mail Merge 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Excel to Word to PDF workflow 1
Linking data in MS Word into Excel 5
Visio 2010 - Deleted shape data fields not disappearing 1
Publisher is filling blank lines with data 2
Import Excel 2010 table into Access 2010 - not listed as range 0
>> Importing from SQL 6

Top