CSV file databases and DAO
-
Hi everyone. I have a program which opens and writes to MS Jet databases using DAO. I want to be able to open a table in a Jet database and convert it to a CSV (comma separated value) database. MSDN says you can use DAO to read/write to CSV databases, but I cannot find any examples on how to do this. Do you use it just like Jet database? Any help is greatly appreciated!
-
Hi everyone. I have a program which opens and writes to MS Jet databases using DAO. I want to be able to open a table in a Jet database and convert it to a CSV (comma separated value) database. MSDN says you can use DAO to read/write to CSV databases, but I cannot find any examples on how to do this. Do you use it just like Jet database? Any help is greatly appreciated!
A CSV file can be created straight huh? Just separate your fields with commas and each record ends with a cr-lf. Nish
Author of the romantic comedy Summer Love and Some more Cricket [New Win] Buy it, read it and admire me :-)
-
A CSV file can be created straight huh? Just separate your fields with commas and each record ends with a cr-lf. Nish
Author of the romantic comedy Summer Love and Some more Cricket [New Win] Buy it, read it and admire me :-)
I could do that, and still might. Creating the file isn't too bad, but parsing it back out will be a chore, possible to do but a chore. I was hoping DAO could read the file back for me. Oh, well :rolleyes: