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

Setting column width in a table with a macro is not working 0
Cell data entering slow! 0
Format column widths from one table to a separate table on same page 1
Booklet in Word, Merge Directory from Excel 0
Exporting Outlook 2007 contact list without losing groups 0
Dates In Excel 5
Need help merging Excel into Publisher Booklet w 2 columns 0
Data Validation when pasting data into tables 2

Top