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.