Knowledgebase
[QODBC-Desktop] How to use QODBC Excel template
Posted by Rajendra Dewani (QODBC Support) on 20 November 2013 04:12 PM

How to use QODBC Excel template 

You can download the QODBC Excel Template, which has a majority of the tables and reports preconfigured.

All you have to do is download the Excel Template and copy the file to Default Template folder

To download the QODBC Default Template, Please click here

After download, Please Copy/Install it to Excel's default template folder
You can copy any Excel workbook into the Templates folder, then you can use the workbook as a template without saving it in the template file format (.xltx or .xltm). In Windows Vista, the Templates folder is usually C:\Users\<your name>\AppData\Roaming\Microsoft\Templates. In Microsoft Windows XP, the Templates folder is usually C:\Documents and Settings\<your name>\Application Data\Microsoft\Templates.

Please Refer Below links for detail

Customizing Excel defaults with templates - Excel - Office.com

or

Where do I find templates? - Excel - Office.com - Microsoft

 

When you start Excel, Please select "My Templates"

Select the "QODBC Default Template" and click.

A new Excel workbook will be created and will automatically fetch majority of the tables and report.

Please feel free to modify the workbook/queries/reports.

 

Also refer

How to Use QODBC with MS Excel 2007

How to Use QODBC with MS Excel 2010

How to Configure QODBC to Work With 64-bit MS Excel

Accessing QuickBooks data with QODBC Driver using MS Excel 2010 & MS Access 2010 (Video)

 

Keywords: msxel desktop download

(1 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).