Question how to import .csv file into access table?

jerry28ph

jerry
Local time
Today, 03:41
Joined
Nov 16, 2008
Messages
141
Hi All,

I'm doing a project on day to day Call Log Sheet and the details are saved in a folder named "callLog.csv" file.

Here is the sample fields and record:
----------------------------------
Call Start : 7:02
Call duration : 00:00:41
Ring duration : 3
Caller : 202-1020
Direction : I
Called No : 155511
Dialled No : 155511

----------------------------------

I would like to ask from you on how I can import and save the sample record into Access table ( I created the .mdb file and table with the same field). I want to use form, command buttons and SQL to perform this task. I have basic knowledge in SQL and working with databases and tables. I will appreciate any help that you may share with me. With your help I know I could make it.

Thank you in advance.

Best regards,
Jerry


 
hi speakers 86,

I read the link that you sent me. I just want to ask about the code written on Scripting Guy site, is it Vbasic code or MS Access code? I have basic knowledge in programming in Access and VB just want to make it sure that it will run on Access code.
Please advise.
Thanks
 
I dont know what vbasic code looks like, but the code in the link looks like vba.
 
Thank you so much for your help I appreciated. Maybe I post another question for more information.
Regards,
 

Users who are viewing this thread

Back
Top Bottom