Append Query not pulling all Data from spreadsheet

[Guest]

I'm a entry-level Access user and I'm working with a DB that someone else
created which (as far as I can tell) uses an Append Query to bring data from
an Excel spreadsheet into a table.

The problem I am having is that it does not bring all of the data. In the
spreadsheet, there is a column named ICD9 Code1. The column is formatted for
text entry and is filled with codes that are numbers (ex 588.81) or an
alphanumeric code (V07.39).

The append query places the data in a table. The data type for the field
these codes are placed in is Text.

The append query pulls all the numeric codes, but does not pull the
alphanumeric codes.

Any suggestions?

 

[Guest]

Try converting the Excel column to text by select the column then selecting
(Excel 2003)
Data->Text to Columns

This will open the 'Convert Text to Columns Wizard'. Be sure to select the
'text' radio button in the 'Column Data Format' section in the Step 3 of 3
dialog window of the wizard.

 

[Guest]

That did the trick! Thanks a bunch!

Try converting the Excel column to text by select the column then selecting
(Excel 2003)
Data->Text to Columns

This will open the 'Convert Text to Columns Wizard'. Be sure to select the
'text' radio button in the 'Column Data Format' section in the Step 3 of 3
dialog window of the wizard.