Hi there.
I have a simple Excel workbook with a VB Macro that attempts to display the contents of a SQL Server database table.
The method used to display the data in the Macro is "CopyFromRecordset".
One of the fields to display is of type "numeric(18, 0)" in the SQL Server table. For some reason, the data contained in this column is displayed as 〱〰㐱〷〰 when it gets as far as the worksheet.
The actual values in the database are along the lines of 1000401000, 1000401001 (so they're not bigger than the "integer" SQL datatype would allow).
NB: This doesnt seem to be a cell formatting issue - the data in the worksheet cells is literally 〱〰㐱〷〰 - it can't be reformatted to display as anything else. Also, the values in the database (1000401000 etc) can be copied and pasted into the worksheet manually with no problems.
Any ideas?
Any help would be appreciated!
I have a simple Excel workbook with a VB Macro that attempts to display the contents of a SQL Server database table.
The method used to display the data in the Macro is "CopyFromRecordset".
One of the fields to display is of type "numeric(18, 0)" in the SQL Server table. For some reason, the data contained in this column is displayed as 〱〰㐱〷〰 when it gets as far as the worksheet.
The actual values in the database are along the lines of 1000401000, 1000401001 (so they're not bigger than the "integer" SQL datatype would allow).
NB: This doesnt seem to be a cell formatting issue - the data in the worksheet cells is literally 〱〰㐱〷〰 - it can't be reformatted to display as anything else. Also, the values in the database (1000401000 etc) can be copied and pasted into the worksheet manually with no problems.
Any ideas?
Any help would be appreciated!