Excel 2016 Get Data from Web: importing table gives dialog box ""

J

JugglingReferee

Board Regular
Joined
Oct 22, 2008
Messages
53
A quick pop up says "Establishing connection to url..."

Then the Navigator window opens up with 2 tables to import. I choose Table 0. After I click Load..., I get this dialog box:

Initialization of the data source failed.

Check the database server or contact ...
Click to expand...

I tried to Google that message but I didn't see anything reliable.

Perhaps you have an inkling what is going on?
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
You must log in or register to reply here.

Similar threads

A
  • Question Question
Import Table Data from Web using VBA to excel Worksheet and able to input Values which can modify the web data to be extract
Replies
0
Views
633
Ambrosia
A
T
  • Question Question
Pivot Table - Conditional Formatting (or selecting) from a Data Table
Replies
0
Views
728
Timbucktoo
T
S
  • Question Question
Experimenting with ODBC DSN to import Excel Data from another Workbook
Replies
0
Views
480
sspatriots
S
A
  • Question Question
Get Data from Web - Connecting Excel Worksheet to Shopify Store
Replies
0
Views
664
AlunM
A
L
  • Locked
  • Question Question
Please Enter Microsoft Office Access Database Engine OLE DB Initialization Information
Replies
0
Views
2K
Legacy 487233
L

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top