Can't import data to access

A

Amin

hi i tried importing my excel table to access but it wont let me. all i know
is the excel book is macro enabled, could that be the trouble?
 
S

Sean Timmons

Macros could always be an issue depending on what they say. However, usually
it's the formatting of the Excel file itself. Are the headers in row 1, any
odd cell values, etc. could mess the works up. A lot depends on what the
error is...
 
S

ShaneDevenshire

Hi,

1. If your data is not in the top left corner of the sheet, you should name
the range. For example, if you name it Data, then in Access when you import
choose Show Named Ranges in the first step of the Import Worksheet Wizard.
2. Access expects all the data in a field (column) to be the same data
type, Excel does not care, so you may need to clean up your data.
 
Top