Connecting to EXCEL, but not being able to define datatypes

[Dougpeplow]

I am using a VBrecordset to connect to data in an 'customer defined' EXcel workbook and then update my access database, after performing some numeric calcs. The process works on some of the worksheets, where the numeric data rows are preceeded by only one or two 'text' rows, but on one sheet, the data rows are preceeded by 14 rows of 'text' or 'null' data. I know the jet engine offers to determine data types by using 'TypeGuessRows', but as this is limited to the first 8 rows, it always assumes 'text'on this sheet. Consequently I get 'numeric overflow' type message when trying to manipulate recordset data with the number values in it. Can I 'force' the datatype to 'Number'? <p> Doug<br><a href=mailto: doug.gray@contactbox.co.uk> doug.gray@contactbox.co.uk</a><br><a href=

http://www.auntiejane.co.uk/>AuntieJane</a><br>

To be added when I can narrow it down a bit

 

[DougP]

yes in Access use the function C___<br>CDBL converts to a double<br>CINT converst to an integer<br><br>usage: <br>YourValue = CBDL(ValueToConvert)<br><br>There are 9 or so conversions for everthing.<br><br>Look in Help <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.