Web Query Import

T

timoc

I have some data on a web page and I want to use the Data/Import
External Data/Web Query to pull the data into an excel spreadsheet.
The problem is that the import tries to interpret the data and changes
it. The first line below is what was on the web, the second line is
what excel changed it to.....I've tried all of the options with no luck
.... I just want it to pull it in as text and not mess with it. Any
ideas?

083934 03830000 05 0.00 30735800000000000060
83934 3830000 5 0 3.07358E+19
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import external data - web query 3
Import Multiple Web Pages 3
Import Data from Access query 8
Data Import into Excel 3
How to create a Web query in Excel? 1
Excel web query does not import table (from yahoo finance) correct 2
Convert $ to actual numbers in an imported web query 1

Top