[dba-SQLServer]Accessing a local file with Query Analyzer

Is there a method of accessing a local CSV file and including it in a query
in SQL Analyzer?

I've done the routine of trying to import the CSV file into the database and
linking to the database with Access to perform the query there and have
failed.  I do not have the access to create tables, and there are too many
indexes on the linked tables for Access (dumping them temporarially is not
an option).

Or, any other ideas?

Thanks,

Mark


This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you.