OLEDB - data incorrectly = text

S

StowerLuke

I’ve set up an OLEDB link between two excel workbooks. When I bring
the data across the first 7 columns convert the numerical data to text
whilst the following columns are correctly formatted as numbers. I’ve
gone back to the source spreadsheet and everything is correctly
formatted as numbers. Why does OLEDB do this ? I cannot find out
how to get the data coming across in the correct format ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Adaptable Macro 9
Getting Radio Buttons to work, that are inserted via AutoText 0
Pivot Table - click through extract data formatting issue 1
Excel OLEDB problem... 1
Differences Between Two Spreadsheets ? 2
Number stored as text 4
Convert numbers stored as text to numbers errors after loading data in 2
Data Type Problem 1

Top