Advanced Search

Access (VBA) Import CSV files into database

/ Published in: Visual Basic
Save to your folder(s)
Import CSV files into a named table in Access database. Use to bulk load tables.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. DoCmd.TransferText acImportDelim, "", "Table1", "C:\Winxp\testing.csv", True, "" 
  2.  ' where table1 is your table

URL: http://www.ozgrid.com/forum/showthread.php?t=32942

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.