Importing Excel Spreadsheet

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
 
J

Joe Fallon

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
Problems Importing from Excel to Access 3
trouble importing from Excel 3
Importing Excel Worksheet 2
Exporting/Importing between databases 2
Can't specify data type during import - Access 2003 3
Something changed but I didn't do it. 5
Column/Field names when Importing HTML 3

Top