Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import CSV file to a table in Access using VBA

Status
Not open for further replies.
ravensks

ravensks

Technical User
Nov 7, 2003
2
0
0
US
I have a CSV file that updates once per day, it contains 15 fields however I want to execute code that imports only the first 6 fields into a table in an Access DB. Preferably, I am trying to set up a form with a cmd button that executes this all in one action. The CSV does contain headers and should copy the headers if they do not already exist.

If anyone could get me started off with some code help It would be greatly appreciated. Thanks!
 
Sort by date Sort by votes
You can use DoCmd.TransferText with an import specification, which will allow you to assign the fields to be imported:
[tt]DoCmd.TransferText acImportDelim, "[blue]A Import Specification[/blue]", "NewTable", "A.csv", True[/tt]

If you are importing a file to an existing table, the data will be appended, if you import to a new table, you can set the argument for field names to 'true' to create field names.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Question
Filter vba problem
Replies
0
Views
86
Moss100
Moss100
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
88
Viswa.R
Viswa.R
Omarahmed22
  • Locked
  • Question
VBA Formating
Replies
1
Views
97
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
135
Moss100
Moss100
aldi07
  • Locked
  • Question
update a front-end database with a new release using vba
Replies
5
Views
95
aldi07
aldi07

Part and Inventory Search

Sponsor

Back
Top