Import from Excel problems..

R

Randy

I have 10 identical Access 2000 databases installed on 10 laptops in the
field. I have created a macro that will, Action: "openquery" with all the
fields in my table except the autonumber field. The macro then sends,
Action: "OutputTo" the floppy A drive. I then collect the floppys onece a
week and run a macro that, Action: "TransferSpreadsheet" and "Import" the
files to my identical table. Usually this work fine. But sometimes I get
and error: "0 files imported" or copied etc, Key violations, or Incorrect
format. How could I have key violations or incorrect formatinng if all the
tables and databases are identical? Any ideas...Thanks...Randy
 

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

Similar Threads

Excel to Access problems 0
Access 2002 Append Query Problems 2
Problem with Import/append 2
import data from excel 2003 to a table in an existing database 2
Import From Excel 2
Import Spreadsheet Problem 3
run saved IMPORT specification from a button in a form 2
Remove warning pop up choice 4

Top