import error... (1 Viewer)

[yavahn]

Hi All
I'm trying to import info from an Excel file into an Access 2007 database, but it gives me the error message:
" is not a valid field name.
What is causing this? I'm trying to over-write the original table, so it should not be trying to force formatting within the existing fields....or so I think.
Anyone know what I can do to remedy this?
Attached is an image of the pop-up

 

[PNGBill]

Why not give it a new table name and then append the data from one table to the other.

 

[yavahn]

Hi PNGBill
I tried to import it with a different name, but got the same error.
Could this be something to do Access 2007 vs 2003?
In the older databases, the import of this specific table works

 

[boblarson]

1. make sure you have no hidden characters in the columns of the spreadsheet (including the areas you aren't actually importing).

2. It is possible that a space or a line feed is in one of the cells and it is causing the problem.

 

[vbaInet]

Since it's referring to a field name, check ALL the field names and ensure that none of them contain invalid/problem characters like:

Space, #, $, comma (,), -, !, [] or {} or (), period (.), quotes etc...

 

[gemma-the-husky]

if its a spreadsheet, and not a csv, then there may be some "bogus" columns

try selecting all the columns to the right of the last one, and deleting them

then access wont think there are some more spurious columns

 

[boblarson]

if its a spreadsheet, and not a csv, then there may be some "bogus" columns

try selecting all the columns to the right of the last one, and deleting them

then access wont think there are some more spurious columns

Exactly! That is what I wanted to express but didn't come close