4 Replies - 6951 Views - Last Post: 07 August 2009 - 08:04 PM Rate Topic:

#1 bmohanty

New D.I.C Head

Reputation: 0

Posts: 3
Joined: 07-August 09

Importing data from CSV file to MS ACCESS

Post icon Posted 07 August 2009 - 04:04 AM

Hi I am trying to import dat from CSV file to Access Database.Can any body help me int his matter??
Thanks in advance

Is This A Good Question/Topic? 0

Replies To: Importing data from CSV file to MS ACCESS

#2 Quin

D.I.C Regular

Reputation: 18

Posts: 359
Joined: 16-October 08

Re: Importing data from CSV file to MS ACCESS

Posted 07 August 2009 - 04:10 AM

Is there not the option File -> Import ???

If you cannot import csv, you can use excel to import csv, save as XLS and then import that into Access.

Was This Post Helpful? 0

#3 bmohanty

New D.I.C Head

Reputation: 0

Posts: 3
Joined: 07-August 09

Re: Importing data from CSV file to MS ACCESS

Posted 07 August 2009 - 05:22 AM

Actually My SAP programme is giving me some data in form of a CSV file..

I want a VB programme to put the data in CSV file to MS access database.

Was This Post Helpful? 0

#4 vb5prgrmr

D.I.C Lover

Reputation: 109

Posts: 1,016
Joined: 21-March 09

Re: Importing data from CSV file to MS ACCESS

Posted 07 August 2009 - 07:48 PM

Couple of ways...

You can loop through file and use insert query or see this thread...

http://www.xtremevbt...ad.php?t=309440

Good Luck

Was This Post Helpful? 0

#5 PsychoCoder

Google.Sucks.Init(true);

Reputation: 1619

Posts: 19,853
Joined: 26-July 07

Re: Importing data from CSV file to MS ACCESS

Posted 07 August 2009 - 08:04 PM

Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Post your code like this: :code:

Thanks.

Was This Post Helpful? 0

Page 1 of 1

Importing data from CSV file to MS ACCESS