importing text 1

[dbpcar]

I am importing the general ledger into an access db. Some of the acct # are a combination of letters and numbers. Even after changing the format of the field to text I cannot import any acct # with letters in them. Help!!!

 

[ErikZ]

Hmm. You're not being very clear. I just did what you wanted to do. I made a text file of prime numbers, the last one I put in a name.

I went into "File", "Get External Data", "Import".

Selected the file.

On the very first Wizard screen I hit "Advanced", changed it from "Long Integer" to "Text".

Hit "next" though all the rest of the menus. My table had all the numbers, and the last item was the name I put in.

 

[Rhonin]

Tried a few different versions of your problem and ran into the following:
If the Acct# column, the first entry in it other than the header is a number, Access changes that import field to integer. To get around this, make record #1 a bogus entry and the field all letters.
For some strange reason even though I changed the field in advanced to TEXT is still set it to Integer if the first field was numeric.
Wonder why?

Hope this might help.

 

[dbpcar]

My excel sheet looks like this:
Month year company account amount

1 12054 1 95530 297895
1 11688 1 95530 122215
1 11323 1 95530 72274
1 12419 1 95530 0
1 10958 1 95530 0
1 11323 1 1501D 0
1 12054 1 1501D 53080
1 11688 1 1501D 85150
1 12419 2 1501D 6260
1 12054 2 1501D 0
1 11323 1 1501W 0
1 10958 1 1501W 0

When I use the import function in access, the account numbers that have letters in them are not imported, all other info gets in okay. The year number is a function of our general ledger system, otherwise meaningless, letters on the ends of the acct number signify contra- or sub- accounts.

 

[dbpcar]

worked fab-gracias

 

[ErikZ]

Er, which solution did you use?

 

[dbpcar]

I USED RHONIN'S SOLUTION

 

[ErikZ]

You should stop shouting and give him a Star.

 

[dbpcar]

sorry about the shouting, I am always in caps and forget to turn it off:
i am clueless on the star

 

[ErikZ]

At the bottom of ever post you see a "Let X know this post was helpful!"

That adds a star.

 

[ZaZa]

This has been a very funny thread!! LOL

Always a pleasure to check out tek-tips first thing in the morning.
_{hope my volume level is acceptable......}