harmmeijer
Programmer
I have made an mdb wich imports a text file and puts it into a table with the TransferText function:
DoCmd.TransferText acImportDelim, "imp", "temp", "c:\backup\test.txt"
This works when I open the .mdb file in Access. Now I want to make a simple application so I do not need Access but I do not know how to use the function TransferText as it is part of the DoCmd wich is part of Access and not of VB6.
Do I need to add a reference, and what ref?
The text file that needs to be imported has got # as seperator and , as decimal seperator.
DoCmd.TransferText acImportDelim, "imp", "temp", "c:\backup\test.txt"
This works when I open the .mdb file in Access. Now I want to make a simple application so I do not need Access but I do not know how to use the function TransferText as it is part of the DoCmd wich is part of Access and not of VB6.
Do I need to add a reference, and what ref?
The text file that needs to be imported has got # as seperator and , as decimal seperator.