Auto Import Access Data

  • Thread starter news.microsoft.com
  • Start date
N

news.microsoft.com

This is probably a scripting question, but hopefully someone can point me in
the right direction. Is there a script or procedure available that can grab
a .txt or .csv file and automatically import the file into an access
database and merge the file. The fields that are in the .txt/.csv file
would be the same as in the Access database. Looking for a way to make this
happen automatically without someone physically importing the file.

Thanks,
 
D

David Lloyd

One approach is the TransferText method. The following KB article discusses
a number of approaches, including this method.

http://support.microsoft.com/default.aspx?scid=kb;en-us;230265

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


This is probably a scripting question, but hopefully someone can point me in
the right direction. Is there a script or procedure available that can grab
a .txt or .csv file and automatically import the file into an access
database and merge the file. The fields that are in the .txt/.csv file
would be the same as in the Access database. Looking for a way to make this
happen automatically without someone physically importing the file.

Thanks,
 
Top