Hi

I regularly import excel worksheets into my Access 2000 DB using
"File... get external data..." Recently however, every time i try to
import a sheet i get the message "not a valid bookmark" and the file
will not import.

Any ideas what is going wrong here?
Thanks for any suggestions.
Paul

paul wrote:
Have you looked at spreadsheet? Are columns heading the same, same
column count, etc?

As a test, can you save the Excel file as a text file, maybe CSV. Then
copy to table struct and attempt to import from the text file into the
new structure? Maybe that will point you to an offending row. Are the
row counts the same?

I've tried importing the file as a text file into an existing table of
the same structure and am still getting the error. Its strange as the
problem has only started to occur recently.

I have a workaround in that i can import the excel sheet into another
application i use (Mapinfo) and this program will then allow me to
save it directly into the mdb but obviously this is a bit more long
winded/annoying that importing directly!

Cheers for any other ideas!
Paul


On Jan 26, 12:34*pm, Salad <o... (AT) vinegar (DOT) com> wrote:

paul wrote:
Well, if you can program...I might take that text file and read it
manually...field by field. Ex:
Dim strFile As String
Dim strLine As String
Open strFile For Input As #1
Do While Not EOF(1) ' Loop until end of file.
Line Input #1, strLine ' Read data line
'now parse out each field and read/append data to recordset
Loop

I wonder if there is some punctuation that isn't expected in the Excel
file or something that confuses the import. That's why I'm thinking is
you can read it line by line and then try to update the table you can
find the line it bombs on.

In my experience, this is the main reason for importing to fail in
general.
There may be some invalid character in the data (a null or non-
printable), or god forbid a stray accidental delimiter or quote..
You might try trimming the file down to N records, seeing what works.
Like, for a 500 row file, try just the first 5 rows, and if there's no
error, keep going until you find where the problem is.
I am not sure that this would cause an invalid bookmark error though.

Your destination table or database may be corrupted, did you try and
compact/repair?