Jump to content

Some Problems With An Excel Query, Help Me!


jot23
 Share

Recommended Posts

Well... I´m having problems making an Excell Query. I am trying to print on screen the fields but it doesn't works. The problem is that I only can print the numeric fields of the first query´s column (6 fields per row) and when I try to print the alfanumerics fields it doesn´t shows anything.In Excell i have this values:==================440700485800578300585000595100B00400E58700EA37800EA49800EA49900NB00400PA12600594800594900595000But when i display the results it shows this:============================440700485800578300585000595100594800594900595000Can sombody help me please????

Link to comment
Share on other sites

You'll need to show your code for anyone to be able to help.
Ok sorry, I didnt´t put the code because i thought that wasnt necessary :) Anyway, here it is:-----------------------------------------------------------------------------------------------------------------set rsXls=ConexionBD.execute("Select * From A1:H725 ")i=1noExisten=""while not rsXls.eof response.Write(rsXls.fields(0)&" "&rsXls.fields(1)&"<br>") rsXls.movenext() wend%><html><body></body></html>-----------------------------------------------------------------------------------------------------------------Excell content:==================440700485800578300585000595100B00400E58700EA37800EA49800EA49900NB00400PA12600594800594900595000Display content:============================440700485800578300585000595100594800594900595000 Edited by jot23
Link to comment
Share on other sites

I don't think that will work, it is an issue with mixed data types within a column, which formatting the cells won't correct.when reading data from the column the data type is determined by the majority of data type within it, the minority will return as null, or empty values. if the data type is equal then numeric values will take precedence over text.try with text data making the majority of the column content, it should now show all numeric values as empty while displaying all text values.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...