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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

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,148,229
Messages
5,745,483
Members
423,953
Latest member
MrC54

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