Multiple Datasource

Legacy Poster

• April 18, 2012 20:51

I am trying to pull information from an Excel spreadsheet and from a Jobboss sql database.
I started with the excel spreadsheet and it pulls in fine but when I add the Jobboss table job and make my joins it gives me an error code 3217 excel not a recognized database. Any help is greatly appreciated

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • April 19, 2012 07:28
  If you added both a Excel sheet and a Jobboss SQL(SQL Server?), your database name of Excel file might be wrong.
  In left pane of database setup dialog, if your excel book name is like "C:\folder\MyBook.xls", right click the book name and modify that to just "MyBook" etc (no path, no extention)

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • April 19, 2012 12:44
  That did it Thanks

  0

Please sign in to leave a comment.