Thanks for the response, I'll check it out.! Derek
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of David L. Penton Sent: Tuesday, September 24, 2002 5:33 PM To: [EMAIL PROTECTED] Subject: RE: CSV --> SQL Server [] DTS [] BULK INSERT [] BCP are all options. DTS is mostly wizard, and pretty simple. BCP is powerful. All are described in SQL BOL (link below) and also check out www.sqldts.com David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of derek bumpas Guys, I need some help. I have a client that is being hosted by CFDYNAMICS and have a SQL Server Database set up with them. The problem is, they want to publish data from their local R:BASE to the SQL Server and the only means they have is to create CSV files for each table. I cannot figure out how to get Enterprise Manager to import the CSV files to the SQL Server without having to recreate the tables. The tables are already defined on SQL and the data just needs to be 'refreshed' from the local CSV files. Has anyone done this? Thanks for any help ! Derek ------------------------------------------------------------------------ - This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
