Importing from Excel: Field order

[Dave32]

Hi all,

I am having problems importing data from Excel to Access.

Do all the fields in Excel need to be in the same order as those in the Access table?

Also, The number of fields in the Excel sheet is less than that of Access, is that a problem?

If I need to reorder the fields so there are the same order in both databases, is there a quick way of doing that in Access?

I do not want to change the order of fields in Excel as I have VBA code in one of my sheets.

Dave

 

[Dave32]

Pat,

Thanks for your reply very helpful. Another question do you have to have the same amount of fields in both Excel and Access?

Dave32