How do import data using | as a delimeter? in Access Database General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
mrniceguy07 10/31/2007 9:29 AM PST
  Question
  How do import data using | as a delimeter?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
SteveM 10/31/2007 9:56 AM PST
   
  Not sure if you can use that character in an Import Specification but you
could always do a Find & Replace on the text file to convert them to commas.
--
Steve McGuire
MCSD, MCAD, MCP


"mrniceguy07" wrote:

> How do import data using | as a delimeter?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Pat Hartman 10/31/2007 12:24 PM PST
  Answer
  File/Import - change the file type, select the file you want to import.
When the wizard opens, press the Advanced button to see the option to change
the delimiter. You should be able to type a character in the field if it is
not in the list.

"mrniceguy07" <mrniceguy07@discussions.microsoft.com> wrote in message
news:B956BE44-39B4-4729-A402-D73F96A8BDA5@microsoft.com...
> How do import data using | as a delimeter?


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
mrniceguy07 11/1/2007 8:33 AM PST
   
  This works perfectly. Thanks for your help!

"Pat Hartman" wrote:

> File/Import - change the file type, select the file you want to import.
> When the wizard opens, press the Advanced button to see the option to change
> the delimiter. You should be able to type a character in the field if it is
> not in the list.
>
> "mrniceguy07" <mrniceguy07@discussions.microsoft.com> wrote in message
> news:B956BE44-39B4-4729-A402-D73F96A8BDA5@microsoft.com...
> > How do import data using | as a delimeter?
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies