Mixed Format data in column won't import into table :(

[NipsMG]

I've got a field thats got mixed part numbers. Some start with letters, some don't.

Example:

184983
BOM961332-001R
861442-01 B
093881-001G

etc...

I'm trying to import this all at once into a table for a project I'm working on, but no matter what i do, I run into problems. If the first item is numeric (i.e. 184983), it tags the field as numeric and anything thats not numeric gets imported as null. If it's the other way around, numbers come in null.

I've tried changing the field type to "text" and many others, but it doesn't work.

Can anyone help?

Thanks.

--NipsMG

 

[dcompto]

See if Edit > Paste Special > Text gives you what you want.

 

[NipsMG]

Problem is, these files come in from suppliers who use them to fill in current component pricing.. The program is supposed to strip the attachments out of a mailbox and automatically dump them into a database without user intervention. I'd like microsoft would have done a better job w/ their OLE db drivers.. :-/

Anyone else have ideas on this one?

 

[dcompto]

Sorry, I see that I didn't "pick up" on the word "table" in your subject line. I thought we were talking Excel.

 

[dcompto]

I haven't been able to duplicate the problem. I place the example data in an Excel spreadsheet, save it, then import it into Access and it imports all the part numbers correctly with the Part field automatically defined as Text.

 

[MePenguin]

Has anyone solved this issue? I have similar problems, mainly cause by Excel sheets with the 'numbers that are formatted as numbers but are not really numbers' problem. Wierd thing is, that when I run the import code on one machine it chooses field formats differently from another machine!