Transfer Text (csv) in DAO

[bugsy]

does anyone know what this code would be like in DAO ?

DoCmd.TransferText acExportDelim, "My_Transform", "Table", "C:\temp\xxx.csv"
[\code]

 

[boblarson]

Can you explain a bit more of what you are looking for and why? The code you posted works, so what about it doesn't work for your purposes?

 

[bugsy]

Can you explain a bit more of what you are looking for and why? The code you posted works, so what about it doesn't work for your purposes?

I am trying to transfer the contents of CSV file to a Table
it doesn't do anything..., and no error message

it did work in macro; but i need the name to contain a date field, so it needs to be done through VBA

 

[bugsy]

I see the problem; i was doing 'export' instead of 'import'
changed; now it works

 

[boblarson]

cool, glad you got it.

 

[bugsy]

thanks, unfortunately it won't let me add to your reputation again (

 

[boblarson]

thanks, unfortunately it won't let me add to your reputation again (

Yeah, you have to give it to several other people before you can give it to someone again.