importing to linked tables

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

Guest

I have a split database with tables in one database and the front end in
another.

I am getting a numeric overflow error when I try to import a text file into
my linked table called CustomerTbl.

If I have a table with the identical structure but not linked but rather
physically in the front end database and import the same text file - I get no
errors and the file imports correctly.

I am using the same import spec on both. What is going wrong?
 
Try compacting/repairing your database. Set your db to compact on close.
 
You must log in or register to reply here.

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 problem into SQL Server 2005 linked table 1
linking tables and relationships 3
can't see new table in back end 5
How to keep someone from importing data out of my database 9
Invalid argument during import 4
How to link a split _be? 1
Ghost references to deleted tables in a back end database (Access2000 XP) 5
Linking Outlook calendar to MS Access 1

Back
Top