Group:  Microsoft Access » microsoft.public.access.externaldata
Thread: How do I import a number from a text file with a coma on it ?

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

How do I import a number from a text file with a coma on it ?
Martin 20.07.2006 14:11:01

Re: How do I import a number from a text file with a coma on it ?
Nikos Yannacopoulos <nyannacoREMOVETHIS[ at ]gmail.com> 21.07.2006 05:51:00
Martin,

Please be more specific! What does the text file look like, and what do
you want to do?

Nikos
Re: How do I import a number from a text file with a coma on it ?
Martin 21.07.2006 23:34:02
How can I custom import ? I have a column with some numbers and some others
that I want to import also as number but in the txt file are in this format:
"1,256" Can I take out " ?

Thank you very much, Martín.

"Nikos Yannacopoulos" wrote:

[Quoted Text]
> Martin,
>
> Please be more specific! What does the text file look like, and what do
> you want to do?
>
> Nikos
>
Re: How do I import a number from a text file with a coma on it ?
Nikos Yannacopoulos <nyannacoREMOVETHIS[ at ]gmail.com> 24.07.2006 13:26:14
Start the process to link the text file; use the options in the wizard
to declare the double quotes as text qualifier. This will result in the
string being read without the quotes in the linked file.

Nikos

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net