column order when import excel data in Access 2007

J

jannkatt

In the previous versions of Access when I imported data from an Excel file to
a table, the order of the columns in the table stayed the same as the
spreadsheet. But when I do the same thing in 2007, the columns are all out
of order in the table. I know I can move the columns in the table but I
don't wan to have to do that every time I import data. Any suggestions?
Thanks.
 
K

Klatuu

It really makes no difference what order the columns are in in the table.
If you want to present the columns in a specific order, use a query.
 
P

Pete D.

I don't get this behavior, are you sure something hasn't changed in
spreadsheet/import specs?
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
VBA - retrieve data on last create named range from previous inserted named range 0
Importing from Excel row order 5
How to import and parse IP column from excel to four fields intoAccess 2007 2
Turning a 3 column flat file into a "3D" Table 2
Import Excel data - need to map columns. 2
Excel in imported in same sort order 2
Import Excel to Access Question 5

Top