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.


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.