docmd.transfertext problem

0

00 Hillary

Hi,

I am using access 97 and tried to import a csv file to the mdb table. I run
a code as following:


DoCmd.TransferText acImportDelim, "Specification4", "input",
DEFAULT_PATH & "online.txt", 1


In online.txt, there is a field which is 10 digit number and I specified it
as a double datatype in the specification4. After the import, I found out
that the 10 digit number data in the field get empty in the destined table
while other fields are all right. Therefore I import manually using
specification4 instead of running code. This time the 10 digit number data
get imported to the destined table. Can anyone please help me on how to fix
the problem so that I run the code? Thanks.
 

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 1
need help 0
Finding the proper style field and the numbered paragraph value within the style 0
Docmd.Transfertext 'Autocorrect' error 2
Creating a Search using a combo box and then creating a report. 4
Finding the right style field in VBA 0
Importing text file with append 1
custom warning message for data import 1

Top