Importing excel into access

M

maw358

I read about a similar problem but didnt find any help... When I
import from excel to access, one column, which has values that are
mainly number and a few letters mixed in, i have erros. For example...
if the import row was 3900000458 it will work, but if it is 0805C45,
it will give an error and come up blank in my table. It seems that any
value with a Letter listed in it creates errors. I cannot figure this
out?? any Ideas?

As well, the drop down box to edit data type when im importing doesnt
allow me to change it.

Appreciate any help! THanks
 
D

Douglas J. Steele

Try creating the table first, setting the fields appropriately, then import
into that table, rather than allowing the import wizard to create the table
for you.
 
J

Jerry Whittle

Another option is to make sure that the first row of the spreadsheet has some
alphabetical characters in the problem field. You can do this by either
moving a valid row to the top or creating a bogus row then deleting it in
Access after the import.
 
M

maw358

Try creating the table first, setting the fields appropriately, then import
into that table, rather than allowing the import wizard to create the table
for you.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)








- Show quoted text -
Click to expand...

Doug,

I tried importing to an existing table with a mask allowing number and
letter characters. The inputs for this column will either be 10
digits with all number, or 5-6 digits with number and letters. I
beleive i used a mask of something like... AAAAACCCCC. Anyway, the
problems still occured. Its a riddle to me?? im an amateur i guess
 
D

Douglas J. Steele

Masks don't serve any purpose when importing (and, as far as I'm concerned,
don't serve much when used for input either!)

Is the relevant field in the existing table text?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I tried importing to an existing table with a mask allowing number and
letter characters. The inputs for this column will either be 10
digits with all number, or 5-6 digits with number and letters. I
beleive i used a mask of something like... AAAAACCCCC. Anyway, the
problems still occured. Its a riddle to me?? im an amateur i guess
Click to expand...
 
M

maw358

Masks don't serve any purpose when importing (and, as far as I'm concerned,
don't serve much when used for input either!)

Is the relevant field in the existing table text?

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)






I tried importing to an existing table with a mask allowing number and
letter characters. The inputs for this column will either be 10
digits with all number, or 5-6 digits with number and letters. I
beleive i used a mask of something like... AAAAACCCCC. Anyway, the
problems still occured. Its a riddle to me?? im an amateur i guess

- Show quoted text -
Click to expand...

I tried what Jerry advised... to make a phony row with letters in the
contract # and then delete it after the fact. It worked! Thanks a
bunch
Click to expand...
 
Top