Latest News

the latest news from our team

ODBC And Microsoft Excel

  1. When  Microsoft Excel opens, click Data on the menu bar, click Get External Data, then Create New Query.ODBCac01
  2.  The Choose Data Source dialog box will appear.  Click mscard* from the Databases tab, then OK.excel2
  3.  Choose available tables and columns to add to your query, click right arrow to add, click Next.excel3
  4.  Click Next.
    ODBCac04
  5.  Click Next.ODBCac05
  6.  Under What Would You Like To Do Next, click Return Data to Microsoft Excel, click Finish.ODBCac06
  7. Under Where Do You Want To Put The Data, click Existing Worksheet, then click OK.ODBCac07
  8. Microsoft Excel – Notebook will appear with your query information.excel8

Leave a Reply

Your email address will not be published. Required fields are marked *