RS not reading data correctly

[tls9923]

I have a VB application that is reading a xls or csv file. It reads the file using ADO into a Record set. It reads some of the records correctly but sometimes it will read blanks on XLS or NULL on csv. I have checked the file and data does exsist. I can read the data correctly using FSO.

Any Ideas

 

[CasperTFG]

does the set up of the RS match though... Is it that Column A started out with low numbers and all of a sudden jumps up to 2 million. You may have started reading it in as integer and then this large nubmer does not fit into an integer so you get NULL instead

Casper

There is room for all of gods creatures, "Right Beside the Mashed Potatoes".

 

[tls9923]

Currently it is a mix of numric and alphanumeric. It reads the numbers correctly. It appears that the field.type is set to integer. Is there any way to change that since I am reading alphanumerics?

 

[ArtieChoke]

The problem is with the Excel driver - it only looks ahead a view lines to determine the field types. You can force the field to be text by using the Data/Text to Columns menu option. Select the column you want to be set to text, then go thru the dialogs until you see the data type selections - then choose text. Don't use the format/cells to text option - that won't do what you want.

"I think we're all Bozos on this bus!" - Firesign Theatre