New guy
|
| Posted: 02/22/2005, 1:52 PM |
|
Hey all, I'm very new to Perl and MS Sql server. A little background of what kind of info i'm looking for...
I just took a new job and the company i'm working with hired another webdesign company to develop the site...The programmer and myself are working well. I was hired to assist in this project and to maintain the database once it is all developed. Right now im scrammbling to find some information on how to get a perl script to interact with (taking data from excel and being placed into a MS Sql server properly). I know that I should convert the excel files to a .CSV file in order to read in the data to a perl script more easily but the problem i have it placing the data properly into the MS Sql database. I have never seen nore worked with a database b4. Thx for the help!
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 02/22/2005, 2:47 PM |
|
I'm not sure, but I suspect that MS SQL Server supports Excel import, thus possibly you could do this with only several lines of code (Perl or anthing else) that execute appropriate SQL statements.
You can find various articles about this here:
http://www.google.com/search?hl=en&lr=&q=import+excel+%22sql+server%22
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
|
