Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006

    Unanswered: How do I import data into access?

    Hello. I've the Microsoft Office 2000 Professional version of Access and have all this data I've extracted and formatted into a text document, however I'm looking for a database program to manipulate this data and make it a little easier on the eyes in an organized fashion but I've no idea how I would automatically import this data into access(Or put into an access document). Is there a way to do this programmatically(Using C or C++)? I'm expecting to handle a large volume of information, so I'm not really seeking to do it by hand.

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    You can import text files, either delimited (where each record is seperated by a delimitting character such as a comma or quotations mark, etc) or fixed length(where each record is the same number of characters long) just using Access. Basically you have to define a table in Access with all the fields found in your text file, and make sure that the table fields match the text file fields in datatype. For all the gory details, fire up Access Help and type in "import text." Then select Import or link a delimited or fixed-width text file.
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Mar 2006
    If you want to do this programmatically then you probably need to look at DoCmd.TransferText and also import specifications.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts