View Single Post
  #1   Report Post  
nc
 
Posts: n/a
Default 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?