Results 1 to 3 of 3
  1. #1
    examart is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Oct 2012
    Posts
    1

    Import Text File Error with quotes being stripped

    Hi,



    I Need Some help, I want to import file from txt file, but I Have Some problem with one record because some double qoute in one column, please help me ho to fix it:

    sample :
    Name Customer
    GEDE Surya
    Budi Bintang
    juni PIE SiSU "OLIVE"

    in last record costumer name with qoute, and make error when import it,

    thanks in advance

    eka

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,422
    The import wizard has no problem with the quotes. Show the code you are using for the import. Is that the exact structure of the text file? Or does that example show the data transposed?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,443
    You can also prior to attempting an import, run a search and replace function on the text file (you can do this from access or just by opening a text editor assuming there are no other instances where you want to retain the "" marks)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. import text file over 255 fields
    By belmontj in forum Programming
    Replies: 2
    Last Post: 04-29-2012, 01:53 PM
  2. Replies: 7
    Last Post: 03-23-2012, 01:55 PM
  3. Import Text File
    By vvasudev in forum Import/Export Data
    Replies: 1
    Last Post: 02-17-2012, 01:57 AM
  4. Import Text File Size Limit
    By wfbp in forum Import/Export Data
    Replies: 1
    Last Post: 11-04-2010, 09:05 AM
  5. Import text file question
    By sumdumgai in forum Import/Export Data
    Replies: 14
    Last Post: 03-23-2010, 07:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums