Importing data from CSV file to MS ACCESS

Importing data from CSV file to MS ACCESS

Page 1 of 1

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

#1 bmohanty  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • 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  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 18
  • View blog
  • Posts: 381
  • 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  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • 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  Icon User is offline

  • D.I.C Lover

Reputation: 109
  • View blog
  • 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  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1633
  • View blog
  • 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