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!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Import csv data to Ms Access existent Table.
Can anybody help me out?- miranhat
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Import csv data to Ms Access existent Table.
Please someone help me out with this...why it's keep freezing?- miranhat
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Import csv data to Ms Access existent Table.
I have found a way from here one of the progs posted the code, to transfer the csv data in to a access table. i think it's connecting but keep freezing. Option Compare Database Option Explicit ' read a csv file into a recordset ' can handle a first line with field names (e.g. a header) '...- miranhat
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Import csv data to Ms Access existent Table.
Thank you for your reply.. But doing append or update query won't help me because i have to import csv every week. I am little confuse for updating the query. Because i want to update my existent table not a new table. I hope i explained it rite. Thank You!- miranhat
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Import csv data to Ms Access existent Table.
Hey there, I want to import csv file to Ms Access in an existent Table. where i have 13 columns. And from the .csv file i would like to pull only the rows from only 4 columns field of informations as new records. I do have same field that is in the csv. All I need to do import csv in Ms Access...- miranhat
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
