newbie - Help!
-
Hi all I need some ideas for a project I am working on. I have data on one server that I can link to a MS Access dB using a driver provided by the application owner. I want to copy those linked tables to a .CSV file, which is not a problem in Access....but I need to write a procedure in VB that will be scheduled to run automatically on a different server than my data (and the dba doesn't want to install Access on this server). I don't know vb well enough to know how to approach this. should I use activeX components or code that reads each table and writes to a .csv? any suggestions are welcomed. tia ca
-
Hi all I need some ideas for a project I am working on. I have data on one server that I can link to a MS Access dB using a driver provided by the application owner. I want to copy those linked tables to a .CSV file, which is not a problem in Access....but I need to write a procedure in VB that will be scheduled to run automatically on a different server than my data (and the dba doesn't want to install Access on this server). I don't know vb well enough to know how to approach this. should I use activeX components or code that reads each table and writes to a .csv? any suggestions are welcomed. tia ca
Hi newbie, The app data and MS Access dB can b on one server while a vb acxtiveX component (with procedure scheduled to run automatically ) is on the other. they link remotely. i don't c the probo here.. :rose::rose: