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

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?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import a comma delimited file & match records 3
create a comma delimited transfer file from one data base to anoth 1
Tab delimited to comma delimited 3
Import Comma Delimited 4
comma delimited file in Word 2007?? 1
Import Delimited File Using Split Function 5
How can I import non-delimited text file into access 3
Comma Delimited-need comma at beginnng & end 2

Top