Import from excel moves columns locations

R

robocope

When I import an excel file into Access 2007 database the order of the
columns is changed. As you go through the import steps all the columns are in
the right order, but once you finish the import and view the table the
columns have been shifted around. Has anybody else seen this and if so is the
shift consistent because I intend to append additional data to this table.
 
J

Jeanette Cunningham

The order of the columns - in databases called fields - doesn't make any
difference to Access.
There are big diffferences in the way a database sets up its fields(columns)
In excel you may have a column for each month or each product or each
location - in Access you would have a single field (column) for month or
product or location. All the month data would have the month name in a
single field, or all the product names in a single field (column) or all the
location names in a single field (column).

Jeanette Cunningham
 

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

Import Excel with more than 255 columns 1
How to save/repeat an import from Excel 1
Import Data from Excel 2
Import Excel Workbook from Sharepoint 4
Import errors importing Text into existing table, header vs no hea 3
Help with selective import from Excel. 4
Access-Excel Import Wizard problem 1
Import from excel, etc. 2

Top