Can't import data to access
 

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?

Can't import data to access
 

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...

"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?

Can't import data to access
 

"...it won't let me" is rather vague. What messages do you see?
--
TedMi

"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?

Can't import data to access
 

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?