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.

Alternatively you can copy and paste the data directly from Excel into an Access table. Open the table in Access and click the top left corner or highlight all the fields (drag through the column headings) and choose Paste. You can create a blank table before you do the copy and paste or you can Paste Append the data to the bottom of an already populated table. In this second case just select the "new" row selector of the table and paste.
--
Thanks,
Shane Devenshire


"Amin" wrote:

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?