Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    19

    Unanswered: Exporting to text

    I regularly export data from an excel spreadsheet to a text file which is then imported to Access but find that there are a lot of double quotes in the text file which have to be manually deleted before i can import the file to my database. Is there anyway to stop this happening?? I'm sure it's something simple but I can't nail it!!

    Thanks in advance!

  2. #2
    Join Date
    Mar 2006
    Posts
    163
    Why the 2 steps?

    Can't you just import directly into Access from Excel?

  3. #3
    Join Date
    Dec 2005
    Posts
    19
    There was a reason why i didn't do it that way in the first place but i can't think what it was!!

    Have tried it again and it works Thanks norie!

Posting Permissions

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