Title: Excel Internet Query
Last modified: August 22, 2016

---

# Excel Internet Query

 *  [StuartJAtkinsonHG](https://wordpress.org/support/users/stuartjatkinsonhg/)
 * (@stuartjatkinsonhg)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/excel-internet-query-1/)
 * I am wanting to export the table of a form we are using via Gravity Forms.
 * I have gone to the Export & Short Code Builder selected Excel Internet Query 
   then entered my login information.
 * I click the generated link and it provides a .iqy file.
 * I open the file and it asks for my username and password which I enter again 
   then unfortunately it says:
 * Unable to open http:Thww.hansonconcretegarages.co.ukt,vp-login.php?redirectto
   =wp-admin%2Fadmin-ajax.php%3Faction%3Dcfdb-export%26form%3DPIease V0213enter%
   28your%213details%213below%26enc%3DHTTALSOMV026action%3Dcfdb-login%26cfdb-action%
   3Dcfdb-export%26user Jogin%3D [NAME] %2540hansongarages.co.uk%26user_password%
   3D [PASSWORD]. The Internet site cannot return the object you request. (HTTP/
   1.0 403)
 * What does the error mean? I have replaced username and password with [NAM.. etc.
   There is an @ symbol in the username if it perhaps not parsing that correctly?
 * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

Viewing 7 replies - 1 through 7 (of 7 total)

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/excel-internet-query-1/#post-5782182)
 * (HTTP/1.0 403)
 * HTTP error code 403 means “Forbidden” usually the user login is not permitted
   to access the page. Check the log that you are using can log in and see the CFDB
   admin panel and its data.
 *  Thread Starter [StuartJAtkinsonHG](https://wordpress.org/support/users/stuartjatkinsonhg/)
 * (@stuartjatkinsonhg)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/excel-internet-query-1/#post-5782206)
 * Is it also possible that the transcoding of the Username may have caused the 
   error the username I use is an email address and so uses “@”. I was using the
   Settings page to create the Export so I know my user has permission.
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/excel-internet-query-1/#post-5782220)
 * Perhaps. You can test this by creating a test user on your site without the @.
 *  Thread Starter [StuartJAtkinsonHG](https://wordpress.org/support/users/stuartjatkinsonhg/)
 * (@stuartjatkinsonhg)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/excel-internet-query-1/#post-5782228)
 * I will do unfortunately our original site designer put a second layer of admin
   rights on new users and we need him to tell us how to give new users new rights:/.
   If it does work I don’t know if you can put some ASCII interpretation to the 
   Username/Password request for when the query reaches your plugin? Although may
   be a WordPress authentication issue.
 *  [motivmedia](https://wordpress.org/support/users/motivmedia/)
 * (@motivmedia)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/excel-internet-query-1/#post-5782275)
 * You might want to try [http://user%40example.com:p455w0rd@yoursite.com/&#8230](http://user%40example.com:p455w0rd@yoursite.com/&#8230);
   An urlencoded @ becomes %40
 *  Thread Starter [StuartJAtkinsonHG](https://wordpress.org/support/users/stuartjatkinsonhg/)
 * (@stuartjatkinsonhg)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/excel-internet-query-1/#post-5782287)
 * I’m still having problems with this. I know there is Documentation on the “Short
   Codes” stuff. Do I need to do a lot of stuff with that to get the .iqy to work
   correctly? I’ve tried going to the Data Tab and selecting my Form then “Export
   Internet Query” it asks for the User/Password which I give and still the same
   problem. My user can see and change any settings, does anyone who this has worked
   for have a step by step they use to get the Excel access to work as a Data Source?
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/excel-internet-query-1/#post-5782290)
 * AFAIK it should work out of the box. But if your site uses something other than
   the default login mechanism, then it probably will not work.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Excel Internet Query’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

## Tags

 * [Excel internet query](https://wordpress.org/support/topic-tag/excel-internet-query/)
 * [iqy](https://wordpress.org/support/topic-tag/iqy/)

 * 7 replies
 * 3 participants
 * Last reply from: [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * Last activity: [11 years, 2 months ago](https://wordpress.org/support/topic/excel-internet-query-1/#post-5782290)
 * Status: not resolved