Query Prompt From Multiple Databases

Legacy Poster

• October 08, 2012 15:17

Hi guys,

I hope this makes sense, I have 2 spread sheets that i am trying to access via a single query prompt, is this possible?
Both spread sheets contain the same column headings just different data, for example..

[code]Spread sheet 1 (English Language)
Product Name PLU PackSize
Product 1 00100 14 Pack

Spread sheet 2 (German Language)
Product Name PLU Packsize
Produkt 2 00101 14 Pack[/code]

I am trying to create a query prompt that searches both spreadsheets by the PLU field.

Many thanks for any help that can be provided.

0

• 

  Domingo Rodriguez

  Moderator

  ★ BarTender Hero ★

  • October 08, 2012 16:09
  Hello,
  
  Are you trying to connect to two sheets within the same Excel spreadsheet, or are you trying to connect to two different Excel files?
  
  Before creating a query prompt, you will need to establish a Join between these two spread sheets you're trying to connect to. Have you done this already via BarTender's database connection setup dialog? Without a Join you won't be able to proceed.
  
  After creating the Join, you can still create a query prompt which will do the search on the new view which resulted from doing a Join between the two tables / databases. You would just choose the "query prompt" and create your prompt.
  
  The below post might also be interesting to you:
  [url="http://seagullscientific.invisionzone.com/index.php?/topic/258-illegal-database-join/"]See Post[/url]

  0

Please sign in to leave a comment.