Importing text data

D

Dave D.

Is anyone having this problem?

I'm trying to import tab delimited data to an existing table in Access using the Import Text Wizard. If I have defined my numeric fields in the existing table as "Decimal", I get an error message saying "Invalid argument". If I have defined my numeric fields as "Double" or "Single", it imports OK.

I have downloaded the latest Jet update, but this didn't fix it.

Dave D.
 

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 does not accept text format! 0
Appending an existing table with imported Excel data 0
Access 2007: Import Text Wizard errors 4
An error occurred trying to import file 'c:\temp\import.txt'. The file was not imported. 0
How to import Start/Finish Data from Excel 1
Access 2000 database Import Spec not working properly 1
Type Conversion Error While Importing (Time Field) 8
Trouble Importing text file into Access 2007 1

Top