Unattended data import

[klm2klm2]

How can data from an external source (e.g. XLS, CSV, etc.) be imported into an Access database in an unattended manner?

This will be used as part of a software revision update deployment. Perhaps a VB program could kick off such a routine. But how would we go about doing it?

Thanks,
Kim

 

[Hap007]

You certainly could use VB, but you could also use Access.

If you used access, here are 2 ways:
1) Use the Access Timer function, set it to fire as often as you would like, and then handle the import/export in VBA code. Have the Access program run automatically at startup
or
2) Use Access to handle the import/export. Then have the Access program run automatically using the windows event scheduler. When the program completes, exit access.

Hope This Helps,
Hap


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

-
Specializing in Access based Add-on Solutions for the Developer

 

[klm2klm2]

The preference is to use VB because the app is currently written in VB. How would we get started, using VB, to import data from an external source into Access?

 

[Hap007]

I could probably struggle through helping you, but since what you want to do is use VB, I would suggest that you post your question in one of the VB Forums here at Tek-Tips.

Hope This Helps,
Hap

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

-
Specializing in Access based Add-on Solutions for the Developer