Excel to Access 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 formating 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

Import from Excel problems.. 0
Append query in macro get key violation - by itself no problem 3
Access 2002 Append Query Problems 2
in Access 2007-TransferDatabase action will not work. 0
cannot expand named range 1
Output Query Results to a Text File 1
Using VBA and recordset's I need to update 3 relational master tables 1
Access 2007 Macro Conditions 1

Top