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

Porter, Mark MPorter at acsalaska.com
Tue Mar 18 13:24:26 CST 2003


Just tried that - too many indexes on the SS table for either a link or an
import :(

Mark

-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us]
Sent: Tuesday, March 18, 2003 10:15 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Accessing a local file with Query Analyzer


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
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


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.



More information about the dba-SQLServer mailing list