Visual Basic, transfer .txt to my existing table in Ms Access

transfer .txt to my existing table in Ms Access

Author	Message
sa #1 / 2	transfer .txt to my existing table in Ms Access I used the command below to transfer the .txt to my existing file called "gbilsts", it do not work, and prompt msg "field f1 doesn't exist in the destination table "gbilsts"" , but when i used the the import wizard in the Ms access it work fine, the problem is how can i used command code to transfer the things to my existing table. DoCmd.TransferText _ transfertype:=acImportDelim, _ tablename:="gbilsts", _ filename:="E:\JTI\gbilsts.txt" i'm appreciated if you can help me on this.
Sat, 31 Jan 2004 10:52:54 GMT

Larry Linso #2 / 2	transfer .txt to my existing table in Ms Access If you are working in the Visual Basic product, not in VBA in Access, there is no DoCmd. DoCmd is Access-object-model specific and exists to allow execution in VBA of functions that would otherwise have been done as Macro Actions. I've personally not been impressed by the import features for text, and, to get exactly what I want, often write VBA code to read the text and save the information in the file. If you're working in the Visual Basic product, that will be your only choice. Quote: > I used the command below to transfer the .txt to my existing file called > "gbilsts", it do not work, > and prompt msg "field f1 doesn't exist in the destination table "gbilsts"" , > but when i used the the import wizard in the Ms access > it work fine, the problem is how can i used command code to transfer the > things to my existing table. > DoCmd.TransferText _ > transfertype:=acImportDelim, _ > tablename:="gbilsts", _ > filename:="E:\JTI\gbilsts.txt" > i'm appreciated if you can help me on this.
Sat, 31 Jan 2004 11:04:41 GMT

Page 1 of 1

[ 2 post ]