Import by append query

R

Rhoda Harris

I used Excel 2000 to create a spreadsheet and tried to import it into Access;
I kept getting a message saying an error occurred and the file was not
imported. I tried double-checking the fields to make sure they were right
(date, long integer, etc.).

Finally, I saw a posting about linking to the spreadsheet and then doing an
append query. So I was able to link the spreadsheet, but when I tried to run
the append query to put the data into a new table, the query wouldn't run or
save. What am I missing?
 

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