Import Table Wizard not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to use the Import Table Wizard to import data from my Excel
spreadsheet to an existing Access Table. I have gone through my Excel
spreadsheet and my Access Table to check for field names and field types. I
constantly get an error message when I try to import a spreadsheet to an
existing table.

And, why can I import the same Excel Spreadsheet into a new table, create an
Append Query and the data combine without problems. I can continue to use
this method but, it is time consuming.

Any idea what I'm doing wrong? Any help would be greatly appreciated.
 
Hi.
I'm trying to use the Import Table Wizard to import data from my Excel
spreadsheet to an existing Access Table.
Click to expand...

Access has many Wizards, but it doesn't have an Import Table Wizard.
I have gone through my Excel
spreadsheet and my Access Table to check for field names and field types.
Click to expand...

For the best chance of problem-free imports, ensure that none of the Excel
columns start with a space, none of these column names are duplicated, none
of these column names are Reserved words, and none of these column names use
illegal characters.
I
constantly get an error message when I try to import a spreadsheet to an
existing table.
Click to expand...

Anyone who reads this question and hasn't read your previous question is
wondering, "What is the error message?"
Any idea what I'm doing wrong?
Click to expand...

The existing table columns don't match the imported table columns, either in
name or data type. Invalid column names get replaced with Field1, Field2,
et cetera. Unless the table being imported into has columns with these same
exact "generic" column names, then the import for those columns will fail.
Import using the Import Text Wizard, and then check the ImportErrors table
for clues.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Back
Top