Macros and TXTs

[shariefoo]

Good morning All.

This is my problem. I need to import a txt file to access using macros not File<Get External Data.

I needed done automatically.

Easy right ? Well here is the tricky part.

I am using the Import Delimited command in macro but the txt file that i have is <tab> Seperated. Meaning that every feild is seperated by a tab. So if i import in automatically using macro it will put everything in one feild.

I tried to create a test txt file with feilds seperated by commas and it worked perfectly. However Macros cant seem to accept Tabs.

Help please ?

 

[Fuga]

I have answered in the other thread. However my answer is in code rather than macro.

My advise is that you use code. It´s actually a lot easier once you get the hang of it a little bit.

Anyway, that´s my opinion. Hope it works out.

Fuga.