Query Prompt From Multiple Databases Follow
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.
Please sign in to leave a comment.