An error occured trying to import the file.

[Crystalguru]

Hello,

I am trying to import an excel file. It has multiple worksheets in it. The first worksheet has imported correctly. When I try to import the second, it gives me the error "An error occured trying to import the file. the file was not imported."

I have searched tek-tips and see that others have ran into this. But haven't been able to find a resolution! argh.

Can anyone tell me what is wrong? I have an assumption that the excel worksheet has a simple problem.

thanks
crystalguru

 

[RobertT687]

Some things I would look for are:
Make sure every column you import has a name and the name isn't a key word and has no invalid characters &,*,%,$ etc. and isn't a duplicate of a another column name.
Make sure the data type Access chooses is correct for the column data. If the first value it encounters looks numeric but should be text try reordering the data or add a dummy first record to force the data type to be correct.

 

[Crystalguru]

Wow! Didn't think it was that sensitive. Should have known that a simple project would turn out to take all day.

I did also have spaces in front of my column headers. That messed it up also.

Thanks
crystalguru