Import Text file into Access

#1

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.

#2

I found the problem. Thanks.

On Jan 23, 11:59*am, angelasg <asguill... (AT) gmail (DOT) com> wrote:

Quote:

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.

#3

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" <asguillory (AT) gmail (DOT) com> wrote

I found the problem. Thanks.

#4

angelasg <asguillory (AT) gmail (DOT) com> wrote in news:38302a66-fb6e-45de-9a46-
0127cbc5da1a (AT) f47g2000hsd (DOT) googlegroups.com:

Quote:

I found the problem. Thanks.

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

#5

"lyle fairfield" <lylefa1r (AT) yah00 (DOT) ca> wrote

Quote:

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."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Import Text file into Access

comp.databases.ms-access comp.databases.ms-access

Import Text file into Access - 01-23-2008 , 11:59 AM

Re: Import Text file into Access - 01-23-2008 , 01:29 PM

Re: Import Text file into Access - 01-23-2008 , 08:00 PM

Re: Import Text file into Access - 01-23-2008 , 08:02 PM

Re: Import Text file into Access - 01-24-2008 , 12:05 AM