Hello,
I have been tasked to produce a pipe delimited file to update a database. Currently the information is received in excel format and the database will only accept pipe delimited. Since several people work with comma and pipe delimited files i would rather not have to keep changing the regional settings. We also have proggramme that changes the , for a |. Pain in the neck since all the files have to be saved to a specific location in order for it the convert them. Is there any vb code that i could use to perform this for me. OR if there is any MS Excel addin that would work this way. I know you can import using the text wizard so why is it so hard to save as a | delimited file.
Hope you can help.
Cheers Craig.
I have been tasked to produce a pipe delimited file to update a database. Currently the information is received in excel format and the database will only accept pipe delimited. Since several people work with comma and pipe delimited files i would rather not have to keep changing the regional settings. We also have proggramme that changes the , for a |. Pain in the neck since all the files have to be saved to a specific location in order for it the convert them. Is there any vb code that i could use to perform this for me. OR if there is any MS Excel addin that would work this way. I know you can import using the text wizard so why is it so hard to save as a | delimited file.
Hope you can help.
Cheers Craig.