delimited, but Non-Comma Delimited file, for input.

  • Thread starter Thread starter Ross.prillaman
  • Start date Start date
R

Ross.prillaman

I'm pulling a file from another program and tring to place it in
Access. This is going to be a daily thing and i would like to cut Excel
out of this loop. I allready have It so you can browse for the file and
select it. what i need is so I cna Imput a file thats using "^" and not
"," as a delimitantor. ( i can't use "," cause there used in fields,
"john,smith MD" , "Bob,Billy PA" , ect.)

is there any way to do it?
 
If you create an import spec for the file, you can use whatever character you
want as a delimiter; however, it is up to the application creating the text
file to include the delimiters. Another option is fixed length fields.
Before you decide how to import the file, you need to determine the export
capabilites of the other application.
 
Back
Top