How do import data using | as a delimeter?

's Computer Specifications

's Computer Specifications

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?

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:B956BE44-39B4-4729-A402-(E-Mail Removed)...
> How do import data using | as a delimeter?

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
> news:B956BE44-39B4-4729-A402-(E-Mail Removed)...
> > How do import data using | as a delimeter?
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data, Text to Columns, has commas in the text, plus as a delimeter	Tonso	Microsoft Excel Misc	2	20th May 2010 02:21 PM
Save Excel file to CSV with quotation mark data delimeter?	Eric	Microsoft Excel Misc	2	9th Dec 2008 04:05 PM
how to treat consecutive delimeter as one when importing data?	=?Utf-8?B?RGFu?=	Microsoft Access External Data	1	7th Mar 2007 07:27 PM
Macro to import delimeter file	=?Utf-8?B?ZGF2ZW1lbA==?=	Microsoft Excel Programming	0	4th Apr 2006 02:57 PM
Import delimeter file into existing table?	Niklas Östergren	Microsoft Access	15	13th Dec 2004 10:46 PM