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

Wortz, Charles CWortz at tea.state.tx.us
Tue Mar 18 13:14:32 CST 2003


Mark,

If this is a one-time-only thing, then try importing the tables from SS
into Access and running your query with the CSV file either linked or
imported.  If this is an on-going operation, then this is not a good way
to go, but it will work.  I have one app that once a day downloads
tables from SS into Access and then runs independently of SS for the
rest of the day.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Porter, Mark [mailto:MPorter at acsalaska.com] 
Sent: Tuesday 2003 Mar 18 13:06
To: 'dba-SQLServer at databaseadvisors.com'
Subject: [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



More information about the dba-SQLServer mailing list