Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    3

    Question Unanswered: importing text file into Access 2000 - nothing!

    I have trouble importing a text file into Access 2000.
    I can import the same file into Access 97 fine, but Access 2000 just ignores the command. The text file has carriage returns at the end of each line. Some of the columns are of equal length and others are not.
    What might be the problem?

  2. #2
    Join Date
    Jan 2004
    Location
    austin
    Posts
    146
    are you doing this in code or a macro?

  3. #3
    Join Date
    Aug 2004
    Posts
    5
    In Access 2000 there's the "TextStream" object which allows you to open any file via VBA. As far as I now, this method never fails. It's also well documented in the help file.

  4. #4
    Join Date
    Aug 2004
    Posts
    3
    I do this by going to Get External Data -> text.txt

  5. #5
    Join Date
    Aug 2004
    Posts
    3
    The textstream object doesn't appear to import the text into a database format. Is it possible to use Get External Data commant that works?

Posting Permissions

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