Importing text into number field- Error

  • Thread starter Thread starter Author
  • Start date Start date
A

Author

I am importing a list of part numbers from Excel into Access. Some part
numbers are like '12345' and some are like 'MUH590G', but when I import the
part numbers with letters in them come out as blank fields. I tried creating
a table, setting both fields to 'Text', and then importing into an existing
table, but I get an error that says "An error occured trying to import file.
File was not imported." It's simple, but it's got me stuck.
Thanks!
 
First, it may not be necessary to import the data ... have you looked into
"link"ing to it?

I'm not following ... "setting both fields" (I thought there was a single
[PartNumber] field).

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Sorry Jeff. You're right- I was trying to tackle two problems at once and
started talking in too many directions. To clarify: I have an Excel document
which has in one column a list of part numbers. The column contains data of
both Number type (i.e. 12345) and Text type (i.e. ABC-123). The Numbers
import into Access fine, but the Text imports as a blank field.
The only way I can get an Excel doc to successfully import is to create a
new table. That's when I get the blank field for any part number with Text
in it, and when I look at the table in design view the Part Number field is
set to Number.
Can you help? If not, am I at least making sense?
Thanks!

Jeff Boyce said:
First, it may not be necessary to import the data ... have you looked into
"link"ing to it?

I'm not following ... "setting both fields" (I thought there was a single
[PartNumber] field).

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Author said:
I am importing a list of part numbers from Excel into Access. Some part
numbers are like '12345' and some are like 'MUH590G', but when I import
the
part numbers with letters in them come out as blank fields. I tried
creating
a table, setting both fields to 'Text', and then importing into an
existing
table, but I get an error that says "An error occured trying to import
file.
File was not imported." It's simple, but it's got me stuck.
Thanks!
 
If I had this task, I'd first create a table definition in Access with a
Text field. Then I'd import the Excel data, appending to that new table/new
field. As I recall, if I tell Access to use Text, then tell it to add
records, it will treat the incoming as Text.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Author said:
Sorry Jeff. You're right- I was trying to tackle two problems at once and
started talking in too many directions. To clarify: I have an Excel
document
which has in one column a list of part numbers. The column contains data
of
both Number type (i.e. 12345) and Text type (i.e. ABC-123). The Numbers
import into Access fine, but the Text imports as a blank field.
The only way I can get an Excel doc to successfully import is to create a
new table. That's when I get the blank field for any part number with
Text
in it, and when I look at the table in design view the Part Number field
is
set to Number.
Can you help? If not, am I at least making sense?
Thanks!

Jeff Boyce said:
First, it may not be necessary to import the data ... have you looked
into
"link"ing to it?

I'm not following ... "setting both fields" (I thought there was a single
[PartNumber] field).

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Author said:
I am importing a list of part numbers from Excel into Access. Some part
numbers are like '12345' and some are like 'MUH590G', but when I import
the
part numbers with letters in them come out as blank fields. I tried
creating
a table, setting both fields to 'Text', and then importing into an
existing
table, but I get an error that says "An error occured trying to import
file.
File was not imported." It's simple, but it's got me stuck.
Thanks!
 
A niggling detail ... if those are "PartNumbers", they are not numbers!
They look like numbers, but I doubt you'd ever want to add or subtract them.
If you are using them as identifiers (and the "alpha" part tells me you
are), then they are ALL text (the "1" is a character just like the "x").

Regards

Jeff Boyce
Microsoft Office/Access MVP


Author said:
Sorry Jeff. You're right- I was trying to tackle two problems at once and
started talking in too many directions. To clarify: I have an Excel
document
which has in one column a list of part numbers. The column contains data
of
both Number type (i.e. 12345) and Text type (i.e. ABC-123). The Numbers
import into Access fine, but the Text imports as a blank field.
The only way I can get an Excel doc to successfully import is to create a
new table. That's when I get the blank field for any part number with
Text
in it, and when I look at the table in design view the Part Number field
is
set to Number.
Can you help? If not, am I at least making sense?
Thanks!

Jeff Boyce said:
First, it may not be necessary to import the data ... have you looked
into
"link"ing to it?

I'm not following ... "setting both fields" (I thought there was a single
[PartNumber] field).

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Author said:
I am importing a list of part numbers from Excel into Access. Some part
numbers are like '12345' and some are like 'MUH590G', but when I import
the
part numbers with letters in them come out as blank fields. I tried
creating
a table, setting both fields to 'Text', and then importing into an
existing
table, but I get an error that says "An error occured trying to import
file.
File was not imported." It's simple, but it's got me stuck.
Thanks!
 
Back
Top