OK then, just go to Tools->Data Transformation Services->import, and export and follow the wizard. You should be alright. If you run into any problems, post them here and I'll take a look.
-Chad -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of PJ Gaenir Sent: Friday, January 23, 2004 9:38 AM To: [EMAIL PROTECTED] Subject: RE: SQL-S Tables/.csv Thanks Chad. This is a one-time need in both cases. PJ On 23 Jan 2004 at 8:41, James Chad Olivier wrote: > Before I explain a solution I have a couple of questions. Is there > any reason ColdFusion needs to be involved in this? Is this a one > time thing or does it need to be scheduled or run on demand? > > -Chad > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of PJ Gaenir Sent: Friday, January 23, 2004 8:20 AM To: > [EMAIL PROTECTED] Subject: SQL-S Tables/.csv > > This is one of those basics it's embarrassing to ask about, but > finding a simple how-to hasn't been as easy as I expected. I have > two things I need to do with SQL Server and ColdFusion and I'm not > sure of either. > > 1 - I need to save a large table from SQL-S (hopefully from > Enterprise Manager) to .csv format. > > 2 - I need to import some .csv/.txt files data into an existing > SQL-S table. > > I'd be grateful for a link to something with instructions. Thanks a > ton. > > PJ --- [This E-mail scanned for viruses by Declude Virus] ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
