Query csv, txt, xls

B

benatom

Is it possible to query csv, txt delimited, or xls files from the
Access query window (or using vba) without importing the file into
Access?
 
K

Ken Sheridan

You can create a link to the file with File | Get External Data | Link Tables
on the main database menu bar (or equivalent if using Access 2007).

Ken Sheridan
Stafford, England
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Macro Loop 0
Office365 Family + TXT or MX Domain 0
How to Write EXCEL files from a FORTRAN Program ? 0
Convert a csv to xls prior to import 2
Some mail merge fields not pulling into document 2
Run-time error ‘13’ mismatch type 1

Top