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

How about BULK INSERT?



>From: "Porter, Mark" <MPorter at acsalaska.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: "'dba-sqlserver at databaseadvisors.com'" 
><dba-sqlserver at databaseadvisors.com>
>Subject: RE: [dba-SQLServer]Accessing a local file with Query Analyzer
>Date: Tue, 18 Mar 2003 10:24:26 -0900
>
>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.
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail