Import Text file into Access

Hello.

I am saving an Excel file as a text file then importing it into Access
using a specification. One of the fields in the file is a currency
formatted with commas. Those numbers over 999 are being interpreted
as text and not imported. I could modify the Excel file not to use
the commas before I import, but I was looking for something more
automated.

I tried making it a text field in the specification, but it still only
imported those numbers under 1,000.

Any help would be appreciated.

Thanks.

Re: Import Text file into Access

I found the problem. Thanks.

On Jan 23, 11:59=A0am, angelasg wrote:
> Hello.
>
> I am saving an Excel file as a text file then importing it into Access
> using a specification. =A0One of the fields in the file is a currency
> formatted with commas. =A0Those numbers over 999 are being interpreted
> as text and not imported. =A0I could modify the Excel file not to use
> the commas before I import, but I was looking for something more
> automated.
>
> I tried making it a text field in the specification, but it still only
> imported those numbers under 1,000.
>
> Any help would be appreciated.
>
> Thanks.

Re: Import Text file into Access

Might help some other participant here, in the future, if you'd say what the
problem was and how you fixed it. Newsgroups are for sharing information,
not just for getting free help.

Larry

"angelasg" wrote

I found the problem. Thanks.

Re: Import Text file into Access

angelasg wrote in news:38302a66-fb6e-45de-9a46-
0127cbc5da1a@f47g2000hsd.googlegroups.com:

> I found the problem. Thanks.

Was it in that column headed, "It's ALL about ME!"?

Re: Import Text file into Access

"lyle fairfield" wrote

>> I found the problem. Thanks.
>
> Was it in that column headed, "It's ALL about ME!"?
>
It recorded the International Database Safety Administration finding of
"Pilot Error."