Importing data from web into Excel 2007

P

Peddling Pete

I am trying to import data from an online database created by my predecessor.
I am successfully using the "Import data from web" dialogue except that it
will only download the first 20 records. The website has dropdown boxes
allowing me to change the number of records to display but the import still
only picks up the default number. I have accessed the online database (in
Zoho Creator) and changed the default to the maximum setting of 200 and I can
then download the first 200 records but not the rest. The problem is that I
can view the rest of the records in the Excel dialogue box but Excel won't
download them. Any ideas on how to download the rest?
 

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

Adding data to MS Access from csv file 0
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
Merging from an Excel file with graphics 1
filter result- total row numbers varies 1
Where is the Data Import Excel button in Excel 2007 6
Copy previous record into form field 0
Importing data from Excel worksheet into Excel template 2

Top