Hi,
I'm trying to import a text file that has been generated by a batch file. The data's columns are separated by dashes '-' in the file. I'm trying to figure out how I can specify the dash as the delimiter in a macro I am making to automate inserting the text from the file into a database but am having a lot of trouble figuring out where or how to do it.
Can anyone give me some idea on what I need to do? thanks!
nick
I'm trying to import a text file that has been generated by a batch file. The data's columns are separated by dashes '-' in the file. I'm trying to figure out how I can specify the dash as the delimiter in a macro I am making to automate inserting the text from the file into a database but am having a lot of trouble figuring out where or how to do it.
Can anyone give me some idea on what I need to do? thanks!
nick