TransferText - changing the delimiter

  • Thread starter Thread starter Crites.Casey
  • Start date Start date
C

Crites.Casey

Is there anyway to change what delimiter the application looks for? I
want to look for "|" instead of commas and can't figure out a way to
do that through code. I know that schema.ini can hold specifications,
but I've looked forever and can't find an example of a schema file for
acImportDelimited. What am I missing?
 
Is there anyway to change what delimiter the application looks for? I
want to look for "|" instead of commas and can't figure out a way to
do that through code. I know that schema.ini can hold specifications,
but I've looked forever and can't find an example of a schema file for
acImportDelimited. What am I missing?
Click to expand...

Access 2003 by the way.
 
Looks like I figured it out. However I now have another question. Is
it possible to look at the specification that I saved from the Import
Text Wizard? I'd like to see what it looks like and maybe fool around
with it a little bit. However, it's not saved as a file on my
computer as it's name doesn't pop up when I search for it. Any
suggestions?
 
Details of the import/export specifications are stored in hidden system
tables in the mdb file; you can use queries to explore them if that sort
of thing turns you on.

Re your preceding question: here's somme schema.ini documentation:

Create a Schema.ini file based on an existing table in your database:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;155512
How to Use Schema.ini for Accessing Text Data
http://support.microsoft.com/default.aspx?scid=kb;EN-US;149090
Schema.ini File (Text File Driver)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp
 
Back
Top