Importing Excel Spreadsheet

  • Thread starter Thread starter IanF
  • Start date Start date
I

IanF

Hi,

When importing excel spreadsheets with no field names,
sometimes access imports the table and assigns field
names "Field1", "Field2" etc and other times it assigns
field names as "F1", "F2" etc.

Can this be predefined?

Cheers
Ian
 
Yes. Use fieldnames! <g>

Not sure about a serious response though.
May be version related.
 

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

Importing Multiple Excel fiels to one Access Database 4
Importing Excel Spreadsheet into Access 6
Change field names to 1st record value 1
Something changed but I didn't do it. 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Problems Importing from Excel to Access 3
Import from Excel to Access 2
Import Excel 2010 table into Access 2010 - not listed as range 1

Back
Top