Import Spreadsheet Problem

[Carl Mankat]

If this is not the correct place to post this point me to it.

I am trying to import an Excel file into a Access 2000 database and it
goes through all of the motions but nothing shows up in my listing of
tables. However, if I us Access 97 and do exactly the same steps, it
imports the spreadsheet into the Access 97 database. I can then copy
that table into the Access 2000 database.

Any thoughts on what is going on would be greatly appreciated....

TIA,

Carl

 

[Vincent Johns]

Something might have short-circuited your importation, such as a blank
row at the beginning of your Excel table.

My suggestion is to copy the Excel file and modify the copy to make it
easier to import. For example, delete the worksheets that do not
contain the table you want to import. Delete rows and columns that are
not part of the table. If the table is arranged so that each record
occupies a column instead of a row, transpose the table. Turn off
filters and unhide all the columns. Put field names into a row at the
top of the table. Examine what you have to be sure that the contents of
the table appear to be valid. Save the modified file.

Then try to import the contents again, identifying the proper types for
date, text, and number fields. If it works, you can delete the copy of
the Excel file, as you used it only to prepare the data for copying.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[jahoobob]

I have never had problems importing Excel Spreadsheets with blank rows.
Carl, I have to ask. What did you name the table? Did you scroll up
or to the right to see if the new table is there in the database
window? What message did you get after you pressed Finish on the
Import wizard?