shell script to transfer flat file generated from isql query to microsoft access database
Can someone help me with a way in shell script to transfer flat file generated from isql query to microsoft access database. Thanks
↪ replying to SlowG
SlowG wrote:
>Can someone help me with a way in shell script to transfer flat file
>generated from isql query to microsoft access database.
>Thanks
>
>
You can use
unload to "myfile.txt" select * from mytable;
which will give you pipe (|) delimited flat file.
Access likely has some sort of wizard like excel to import delimited
files, doesn't it (No idea, never used the thing ;-) ).
HTH
Michael