Excel Microsoft query
 

Hi

I have a few queries,

1. Can a .txt file be joined to another database table?

2. Can I join a two tables in different sheets in the same workbook?

3. I tried to query a table on Excel sheet using the source as Excel
Files*, but a field populated with numbers returned blank cells as the
results. Why?