Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 03-09-2006, 01:17 PM   #1
Posts: n/a
Access import fails at any double quote

When importing an ascii text file into access and selecting a delimiter file type and selecting: other (other being the pipe: | character) and type the pipe character into the box. Access import fails/errors at the first double quote character (") within the file. Needless to say, I need to allow douple quots with the file imported to Access.

How to stop Access from failing at any double quote character:


  Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Spreadsheet Data into Access mmitchell General 1 02-10-2005 02:40 PM
How to open a Access file exclusively just by double click the .mdb file name? amolin General 3 08-09-2004 09:27 PM
Access 97 large text file import problem pennisj3 General 1 08-04-2004 04:26 AM
Import Excel to Access EndersG General 2 04-15-2004 10:43 AM
Export to Excel and Import to Access Data Slave Macros 2 08-24-2000 11:03 AM

All times are GMT -8. The time now is 06:56 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World