Having played about with it, that'll only work for databases, so you could do it that way if you converted the spreadsheet to Access, but not if you need to leave it as a spreadsheet. Dan
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of GJ Sent: 15 June 2005 01:51 To: [email protected] Subject: Re: [AspClassicAnyQuestionIsOk] Help in Exporting data Can you show me the code for that? Thanks! On 6/14/05, Dan Powderhill <[EMAIL PROTECTED]> wrote: > Creating a table is simple enough using the create table SQL. The only > way I can think of getting the data in to the table without using DTS or > an ASP / VB script would be to set the spreadsheet up as a linked table > and do a select statement from it into the new table. > > Dan > > ________________________________ > > From: [email protected] > [mailto:[EMAIL PROTECTED] On > Behalf Of GJ > Sent: 14 June 2005 04:36 > To: [email protected] > Subject: Re: [AspClassicAnyQuestionIsOk] Help in Exporting data > > > Thanks Mark for the reply but I'm not asking for an ASP code or > vbscript...What i'm asking is it possible to create a database table > in the Enterprise Manager without using the DTS or what we call wizard > and instead use Query Analyzer...Tnx! > > On 6/12/05, Mark E <[EMAIL PROTECTED]> wrote: > > Here is what I use to allow clients to run imports of > > new items in SQL from a .csv file: > > > > 'Create our FSO. > > set objFSO = > > Server.CreateObject("scripting.FileSystemObject") > > > > 'Set the path to the error log file. > > strPath = server.MapPath("NewItems") & > > "\NewFCIItems.csv" > > > > 'Check to make sure the file exists before we process. > > if objFSO.FileExists(strPath) then > > > > 'Get the text file that we will be reading. > > set myFile = objFSO.GetFile (strPath) > > > > 'Open the text file. > > set objTextFile = myFile.OpenAsTextStream(ForReading, > > -2) > > > > 'Loop thru the text file and get all the text, assign > > to variable. > > Do While not objTextFile.AtEndOfStream > > > > 'Grab each line in the file, store in variable. > > strText = objTextFile.ReadLine > > > > 'Evalute the line to see if data exists. > > if len(trim(strText)) > 0 then > > > > 'This is the code that extracts the items from the > > line. > > Dim strMyArray, intMaxIndex, intCurrIndex, > > strCurrValue > > > > 'Parse the string passed in, sperating by commas ",". > > strMyArray = split(strString, ",") > > > > 'Find out how many fields we parsed. > > intMaxIndex = UBound(strMyArray) > > > > > > 'Make sure we have all the required fields. > > if intMaxIndex = 3 then > > 'Parse out the values from the string passed in. > > strVar1 = strMyArray(0) > > strVar2 = strMyArray(1) > > strVar3 = strMyArray(2) > > end if > > > > 'The file is not blank, process. > > strInsertSuccessful = InsertNewItem(strVar1, strVar2, > > strVar3) > > > > 'Check the response from the insert above and set err > > if found. > > > > End If > > > > Loop > > > > End If > > > > 'Close & destroy the file. > > objTextFile.close > > set objTextFile = nothing > > > > Mark > > > > > > --- goriojuan <[EMAIL PROTECTED]> wrote: > > > > > Aside from using DTS and Export wizard, how can we > > > export data from > > > Excel to SQL Server2000 database. What is the exact > > > script used to do > > > this. Help is highly appreciated. > > > > > > > > > > > > > > > ________________________________ > > Yahoo! Groups Links > > > > To visit your group on the web, go to: > > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > > > To unsubscribe from this group, send an email to: > > [EMAIL PROTECTED] > > > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > ________________________________ > > Yahoo! Groups Links > > > * To visit your group on the web, go to: > > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] > subscribe> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/> . > > > > > [Non-text portions of this message have been removed] > > > ________________________________ > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ________________________________ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] subscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
