Transfertext Method

[angel007]

Hi,​

I need some help with Transfertext Method…. When I run my vbscript code it inserts empty rows instead of data..​

　​

Please can anyone look into this and let me know what I’m doing wrong…​

[/INDENT][INDENT]A.DoCmd.TransferText acImportFixed, "Spec name", "test", "C:\\test.txt"

Thank you!
​

 

[Alansidman]

According to this site, your syntax appears correct if you ignore the A. What does that represent. Is it integral to your code?

 

[angel007]

Hi,

My bad!

Here is my complete code...

Dim A  
 Set A = CreateObject("Access.Application")  
A.OpenCurrentDatabase ("C:\test.mdb")  
A.DoCmd.TransferText acImportFixed, "Spec name", "test", "C:\\test.txt"
Set A = Nothing 
msgbox "Done!"

Thank You!

 

[boblarson]

So is that a completely different database than the one that the code is in? Also, is the Import Spec actually inside of C:\Test.mdb? And third, your file path is wrong as there shouldn't be two backspaces for "C:\test.txt"