Text data not importing into Access from Excel

glane

New Member
Joined
Jan 17, 2005
Messages
1
I am importing an Excel spreadsheet into Access. One of the columns, contains the following types of data:

Numeric - 12345
Alphanumeric - 123L
blank cells
Alpha - New PO Number

I have formatted the column as text in Excel and described the column in Access as text. Access imports the column that contains 123L and the column that contains New PO Number as blank. If I remove the L, I still get blank unless I format the column using the parsing method - data text to columns. However, I still cannot get the alpha data to import. I understand that formatting cells in Excel only means that you are formatting the way they look, you are not changing the actual data.

How to you handle all four situations in one column? The data is being imported from different applications and is being manipulated manually in Excel. We are working on the automation of this process, but need to solve this problem right now.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
What happens if you make it a characer field? Won't that work?

texasalynn
 

Forum statistics

Threads
1,182,047
Messages
5,933,394
Members
436,892
Latest member
tommsegers

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top