Importing into Linked Table

L

Lisa Beach

BlankI have a SQL database linked in Access. I need to import information
from an excel spreadsheet into the linked database.

To test it - I imported my SQL table into it's own database (basically a
copy of the linked table) and tried to import the Excel file. It goes
through the wizard and then I get an error stating that it could not
import - it doesn't tell me what the error is.

Here is the information - the SQL table contains 24 columns w/ one auto# and
no primary key. The excel file contains the same # of columns. I created a
column for the auto # field and filled in the fields thinking that would fix
my problem. In the SQL database I go to File>Get External Data>Import and
select the Excel file. It shows me the column headings and data > click
next > choose in an existing table > click next > It comes to the final
screen stating the table name > click finish > "An error occurred trying to
import file C:\....book1.xls. The file was not imported."

So, then I created a new database from the excel file and tried to import
that table into the SQL database and all it does is create another table - I
need it to add to the linked SQL table.

Thank you in advance for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top