Hello everybody!
It is my first post so nice to meet you
I have got the following problems:
- I try to import txt file to Access table in two ways:
1)
Sub nn()
DoCmd.TransferText acImportDelim, "schema.txt", "testtable3", "D:\dd\test.txt", False, ""
End Sub
schema:
[test.txt]
Format=Delimited(
the structure of the file which I try to import:
text1;text2;text3;text4
zzz;ddd;sss;aaa;
www;kkk;lll;ppp;
Result: access window shows me that the specification of file shema.txt does not exist
2)
Sub nn()
DoCmd.TransferText acImportDelim, "", "testtable3", "D:\dd\test.txt", False, ""
End Sub
Result: I have one column and two rows and header in testtable3 but i want to have header, two rows and four columns
thx for help