Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







MS SQL Cheat Sheet?


Anyone know the web address of a site that has all of the SQL statments / commands available in MS SQL Server 2005?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Cheat Database Design
hi im new to sql and so im sorry if this is a stupid question

im looking to create a cheat database,(dont worry it wont be another useless cheat website, i have something up my sleeve)

what is required is
Disc Name
Disc ID -- (there will be multiple of these for each Disc Name)

Cheat Name
Cheat Description
Cheat Code

Walkthrough Name
Walkthrough Description
Walkthrough Link

it is a bit fuzzy and im having trouble describing it but this is what i was thinking

have a database called CheatProject
a table called Users (where user account are held)

a table called Games
--KEY, Game Name, Game Disc 1, Game disc 2

a table called Cheats
--KEY, Cheat Name 1, Cheats Description 1, Cheat Code 1, Cheat Name 2, Cheats Description 2, Cheat Code 2

a table called Walkthrough
--KEY, Walkthrough Name 1, Walkthrough Description 1, Walkthrough Link 1, Walkthrough Name 2, Walkthrough Description 2, Cheat Link 2


would this work,
also you can create more columns in php script, if required

sorry for being a noob, at this

View Replies !   View Related
Reading From A Xl Sheet
Hi All,

I would like to know if i can read data from xl sheet using a stored procedure?

Thanks in advance

vishu

View Replies !   View Related
DTS Import Of Excel Sheet
I'm using a SQL 2000 SP1 DTS DataPump task to import a single Excel 5.0 spreadsheet to a table. In ONE of the Excel columns are integers, but only after several hundred rows of NULL values. After import, I noted that there were null values in the corresponding SQL table's field for ALL the records. After several trial-and-error sessions I noted that if I put a non-null value in one of the first 9 rows for this Excel column, then import reads the values in correctly. I think this may be a bug. Could someone try this out or enlighten me as to the reason for this behavior?

View Replies !   View Related
Dropping Excel Sheet
I guess nobodys heard of this? I'm using DTS to transform data to Excel spreadsheet. I have a DROP TABLE `data$` then a CREATE TABLE `data$` the old data is cleared but the new data is appended to the blank rows of the old data. So if I had 5 rows before now I have 10. And the new data has 5 blank rows before it.

I've tried deleting the excel file & replacing it with a new one.
I've used the wizard thinking it was me but no good, it still happens.

HELP!

View Replies !   View Related
Balance Sheet Calculation
Hello Friends,

I have a doubt regarding balance sheet calculation in my Software. I am using a stored procedure for these calculations. I have some commands for calculation as given below:

/******************************************************************/
DECLARE @car_req FLOAT
DECLARE @amt_gen FLOAT
DECLARE @amt_shp FLOAT
DECLARE @amt_sho FLOAT
DECLARE @bal_gen FLOAT
DECLARE @bal_shp FLOAT
DECLARE @bal_sho FLOAT
DECLARE @tab_id INT

CREATE TABLE #Temp
(
rec_id INT IDENTITY NOT NULL
,cargo_requiredFLOAT
,amount_generalFLOAT
, amount_shipFLOAT
, amount_shoreFLOAT
,balance_generalFLOAT
, balance_shipFLOAT
, balance_shoreFLOAT
)

INSERT INTO #Temp (cargo_required, amount_general, amount_ship, amount_shore)
SELECT 5000, 1500, 1450, 1490
UNION ALL
SELECT 0, 3500, 3500, 3500
UNION ALL
SELECT 7000, 4500, 4550, 4560
UNION ALL
SELECT 0, 2500, 2000, 2000


DECLARE temp_cursor CURSOR FAST_FORWARD FOR
SELECT rec_id, cargo_required, amount_general, amount_ship, amount_shore
FROM #Temp

OPEN temp_cursor

FETCH NEXT FROM temp_cursor
INTO @tab_id, @car_req, @amt_gen, @amt_shp, @amt_sho

WHILE @@FETCH_STATUS = 0
BEGIN
IF (@car_req > 0)
BEGIN
UPDATE #Temp
SET balance_general = @car_req - amount_general
,balance_ship= @car_req - amount_ship
,balance_shore= @car_req - amount_shore
WHERE rec_id = @tab_id
END
ELSE
BEGIN
UPDATE #Temp
SET balance_general = @bal_gen - amount_general
,balance_ship= @bal_shp - amount_ship
,balance_shore= @bal_sho - amount_shore
WHERE rec_id = @tab_id
END

SELECT @bal_gen = balance_general, @bal_shp = balance_ship, @bal_sho = balance_shore
FROM #Temp
WHERE rec_id = @tab_id

FETCH NEXT FROM temp_cursor
INTO @tab_id, @car_req, @amt_gen, @amt_shp, @amt_sho
END

SELECT * FROM #Temp

CLOSE temp_cursor
DEALLOCATE temp_cursor

DROP TABLE #Temp

/***************************************************************/

This is what acutally I am having in my stored procedure except the temporary table. The values which I am inserting here will get from my actual tables. What I need is to calculate balance. If you run this script you can see how the balance is calculating using the cursor.

I want an efficient way to calculate the same. I know cursor is not at all good option in stored procedures. Do you have any Idea to make this script in an efficient and simple way?

Thanks and Regards
Boney

View Replies !   View Related
Export To Excel Sheet
I have a table calld studentMaster

I want export this this table to excel sheet.

please help me any one

View Replies !   View Related
Balance Sheet Calculation
Hello Friends,

I have a doubt regarding balance sheet calculation in my Software. I am using a stored procedure for these calculations. I have some commands for calculation as given below:DECLARE @bal_gen FLOAT
DECLARE @bal_shp FLOAT
DECLARE @bal_sho FLOAT
DECLARE @tab_id INT

CREATE TABLE #Temp
(
rec_id INT IDENTITY NOT NULL
, cargo_required FLOAT
, amount_general FLOAT
, amount_ship FLOAT
, amount_shore FLOAT
, balance_general FLOAT
, balance_ship FLOAT
, balance_shore FLOAT
)

INSERT INTO #Temp (cargo_required, amount_general, amount_ship, amount_shore)
SELECT 5000, 1500, 1450, 1490
UNION ALL
SELECT 0, 3500, 3500, 3500
UNION ALL
SELECT 7000, 4500, 4550, 4560
UNION ALL
SELECT 0, 2500, 2000, 2000



SELECT @bal_gen=0,@bal_shp=0,@bal_sho=0
SELECT @tab_id=MIN(rec_id)
FROM #Temp

WHILE @tab_id IS NOT NULL
BEGIN
UPDATE #Temp
SET @bal_gen=balance_general =CASE WHEN cargo_required > 0 THEN cargo_required ELSE @bal_gen END - amount_general
, @bal_shp=balance_ship = CASE WHEN cargo_required > 0 THEN cargo_required ELSE @bal_shp END - amount_ship
, @bal_sho=balance_shore = CASE WHEN cargo_required > 0 THEN cargo_required ELSE @bal_sho END - amount_shore
WHERE rec_id = @tab_id

SELECT @tab_id=MIN(rec_id)
FROM #Temp
WHERE rec_id >@tab_id
END

Select * FROM #Temp
This is what acutally I am having in my stored procedure except the temporary table. The values which I am inserting here will get from my actual tables. What I need is to calculate balance. If you run this script you can see how the balance is calculating using the WHILE loop.

I want an efficient way to calculate the same. Is there any way to calculate it without using loop methods.
Thanks and Regards
Boney

View Replies !   View Related
Read Each Excel Sheet
Hi,
I have an excel spreadsheet with several sheets.
These sheets get populated with data from an external source database i.e. a third party application.
I would like to create a SSIS package to read the data in each sheet.
Please note that I do know how to create SSIS package to read an excel file with only one sheet.
Is there a functionality in SSIS to loop though each sheet in one excel file?
Thanks

View Replies !   View Related
Xml Input Using Xml Style Sheet
Trying to install SQL express but can't. I used the uninstall tool and it keeps hanging up on this error.

I am using XP and IE7.

I have also adjust my security setting to allow cross domains. Short of going and getting another machine I am at a loss.

No beta software is on machine and I also cleaned the registry..



I am not a developer. This looks like an issue all around MS..

View Replies !   View Related
Listing All SQL SErver And Fill A Sheet
Is possible to fill a sheet with the name of SQL Server in my formnetwork? In effect scan all server in my farm lan and get only the nameof SQL Server and put info into a sheetTks.*** Sent via Developersdex http://www.developersdex.com ***

View Replies !   View Related
Converting SQLTable To Excel Sheet
I am able to export to excel through a stored procedure.But when iopen it the datetime column and int columns are not getting recognised.

View Replies !   View Related
Table Join Between Excel Sheet And MS-SQL
My company has recently transitioned to a centralized Oracle database model.
For the sake of security, the "powers that be" have also denied any query ability to any central tables. They refuse to create views or any other open tables for people to query.
Instead, they provide a "tool" which people can use to download data - to Excel Spreadsheets.
In the past, before this "improvement" lots of users in the local plants were able to query the old system to bring data into spreadsheets for reports, analysis, etc.
Now the place is jammed to the hilt with linked spreadsheets - people do their "table joins" with linked cells and Excel VLookups (yuk). This is because the "powers that be" still demand that these reports, analysis, etc. be done.

I am trying to use SQL-DMO to create a table join between one of these Excel Data pulls and a MS SQL Server table in Excel so that I can join without VLookup. IS SQL-DMO the right way to go?

Has anyone done this? I think I am close, but I don't know how to use the SQL-DMO attached Excel table object I've created in a join. I can't see the object in MS Query. I am not adverse to doing the whole thing in VBA...

Here is another question. Most of these Data pulls using the "tool" (ball and chain, boat anchor) are done once a day or once a week. Would a better strategy be to create MS SQL server Tables that are dropped and re-written when the data is pulled into Excel? This would mean that the report worksheet does not have to import the Excel Data pull sheet to MS SQL when it updates its query.

View Replies !   View Related
How To Transfer Data From Spread Sheet
how to transfer data from Excel spread sheet to table in the data base table..?

View Replies !   View Related
Has Anyone Done A Balance Sheet With Analysis Services?
Hello All,

What I'm trying to do is create:

Beginning Inventory
+ Orders
- Sales
-------------------
Ending Inventory

for any given date range (day, week, month, year, 15th to 15th, WHATEVER!)


How do I tell the cube to provide the Beginning Inventory for the First day in whatever date range? My SQL table has beginning inventory saved for every day.

Seems simple but I can't figure it out.

Thanks for your help!

View Replies !   View Related
Update Sql Server From Open Sheet
hi all
any body help me for my problem in my code
i need to update my sql from excel sheet. but my excel sheet must be open all time, coz it connected with server to update value into this excel sheet.

and i put this code in calc event into this excel sheet:

SqlCom.CommandText = "Update DirectMarket Set DirectMarket.StockVolume=T2.Volume, from DirectMarket inner join (Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D: est.xls;HDR=YES','SELECT * FROM [Sheet1$]')) T2 On DirectMarket.StockSymbol = t2.Symbol "

but this code ask me to close excel sheet to complete update data into SQL server.
i cant close file cose it updated all time.

so please i want to know how can i do update data while excel file is open ????

thank u so much for all.

View Replies !   View Related
Excel Destination Spread Sheet
Hi,

I've a problem with excel destination spread sheet.I've created a package which pulls the data from sql server and load it into excel sheet.The main thing Ive to do is I've to create different destination tables(work sheets) for different data.i.e.,The source is a sql query which pulls the data in groupwise with group by clause.So,I've to create individual work sheet for each group with that data.How it can be done.Please, advice me.

Thanks in advance.

View Replies !   View Related
Cascading Style Sheet To The SSRS
How to write CSS Class in XML with schema. And how to attach this CSS Class to the object. Plz help!!


gunja

View Replies !   View Related
Is There An Option Of Adding Style Sheet For The S
Can I set the default style of my report like we do thecss in web development
I don't want to edit the style of the report manager .What I want is to edit the report style. [mean the rendering style of the actual report]

Suppose I have to set borderwidth of table =.25pt

bordercolor of table,all of it's cell to silver.

Borderstyle to be windowsinset.

Backgroundcolor of the full layout to be black

How Can I do that ?

View Replies !   View Related
Specify Excel Sheet As A Configuration Property.
Hi,

I'm just starting with SSIS and want to create a reusable package which imports from an excel file which can be specified at runtime. I can expose the filename of the excel file as part of the connectionString property but the sheet is the openrowset property which is a custom property and therefore isn't exposed as part of the external configuration. Does this make sense? Is there an easy way to specify the sheet to import at run time?

Regards,
Anthony.

View Replies !   View Related
How To Assign Values To A Variable From A Xls Sheet?
I've got this query inside a Sql Task against a Excel connection and I'd like to insert that value into a user variable called "Proyecto". How do I such thing?

select Proyecto from [Carga$]

TIA,

View Replies !   View Related
Selecting The First Sheet In An Excelfile When Using For Each Loop
I have a For Each Loop which cycles through some Excel files which is delivered to a FTP location.

In the loop the DataFlow Task uses a Excel Connection Manager, in which you have to specify which sheet you want to take the data from.

But what can i do if the sheet name is different from file to file ?

I was thinking about a script task which somehow can read the first sheet in the Excelfile thats found in the Loop -> put it into a variable -> and use that value tobuild the query in the Excel Source

Anyone got a solution for this problem ?

View Replies !   View Related
Transfer A Sheet From Excel In To Sql Table
I would like to transfer all the cells of an excel sheet to a temp table
in such a way that there is no data loss and no rows of columns of data are made to Null or omitted.

take a example.

Tanks

View Replies !   View Related
Could We Change The Excel FileName And Sheet Name
Hi ,
I am using SQL Server Business Inteligence Developement Studio for SSIS. I want to change the Excel FileName and Sheet name for excel source at the run time. Please suggest me how is it possible.

View Replies !   View Related
Setting The Sheet Names In Excel
Hi,

I have a main report with some sub reports. I put the sub reports in a rectangle and selected insert page break before on the rectangles.

If I run the main report and then select export to excel the sub reports are called Sheet1, sheet2, sheet3

How can I change those sheet names ?

I tried setting the bookmark, label and tooltip but no luck.

If I only export 1 report, the name of the sheet is the name if the report.

So how can I fix this ?

Constantijn Enders

View Replies !   View Related
Applying CSS Style Sheet To A Report..
Hi,
i have created a rdl file with 10 columns.Also i have an aspx page which will list the ten columns. The user can select some columns and on clicking report button report will be generated in PDF format(Using the rdl file).
Now i want to apply style sheet to the report dynamically from aspx page.. how to do that..Help me.
Thanks in advance

View Replies !   View Related
Importing Data From Excel Sheet
i using the select command

select * from [excel sheet name$];

i also using open file dialoug to specify the excel book this book should be pass to the select command at run time
as a parameter

so plz help me with suitable example

View Replies !   View Related
Read The Work Sheet Irrespective Of Its Name
Hello,

I am writing the Application in VB to Read the excel. My Excel Contains 6 to 7 sheets in it. But the Sheet name changes frequently. As the application reads the sheet automatically so if I want ot read these sheets irrespective of its name the how is it possible in VB?

I am using the ADO Connection to read the Excel File and thats my recquirement.

Regards,
kiran

View Replies !   View Related
Transform Data To Excel Sheet Or Xml
Does SQL 2005 Express have standard functionality on board to export data as an excel sheet? or as XML in a specified format?

View Replies !   View Related
How To Create A Spread Sheet From A Sql Table Results?
I have to run a simple query (say select name from table where id = 4) and get those results and make it into a report.  I am not sure I have crystal reports (do I have to install some thing for this?).  So what is the easiest way to create this?  May in in a spread sheet  or some thing like this?  I am so new to SQL Server
Thanks

View Replies !   View Related
Import Data From Excel Sheet To Sql Database-asp.net 2.0
In admin tool of my application,i want to give facility  to administrator that he can import data from the Excel Sheet and can insert in sql database. for example...user id and password that from excel sheet to user table in sql database.
how can i do this..please help me. it's urgent.
thanks
raj

View Replies !   View Related
How To Export Data From DB Table To Excel Sheet
Hi .,
  Can any one guide me in exporting data from DB table to excel sheet .
 
Thanks,
vijay
 

View Replies !   View Related
Formatting For Writing My Query To An Excel Sheet
Hi ,

I am executing my query and writing it to an excel sheet by choosing "query" results to an excel sheet. It does not format them well. I have trimmed my fields too. There are about 10 fields in the database and I need to show them in the excel file all the ten fields adjacent to one another. Is there anyway I can format them other than the programming aspect.

Thanks

View Replies !   View Related
EXcel Sheet Into Database With Stored Procedure
Hi,What is the syntax of storing the content of an Excelsheet in a predefinedtablewith a stored prcedure.Arno de Jong, The Netherlands.

View Replies !   View Related
Listing In A Sheet All Server Of Netwaor With SQL Installed
Is possible to fill a sheet with the name of SQL Server in my form network? In effect scan all server in my farm lan and get only the name of SQL Server and put info into a sheet
Tks.

View Replies !   View Related
Transfer SQL Data Results To Excel Sheet
-- (1) Number of calls received for each priority of call [for a specified date range]

declare @startdate datetime,
@finishdate datetime

select RM.fldPriorityCode as 'Priority',
count(RM.fldRequestID) as 'Calls'
from tblRequestMaster RM
where RM.fldPriorityCode between 1 and 5
and RM.fldRequestDate between '01-01-2007' and '03-05-2007'
and RM.fldRequestFlag like 'D'
group by RM.fldPriorityCode
union
select
'Total' as 'Priority',
count(RM.fldRequestID) as 'Calls'
from tblRequestMaster RM
where RM.fldPriorityCode between 1 and 5
and RM.fldRequestDate between '01-01-2007' and '03-05-2007'
and RM.fldRequestFlag like 'D'
order by RM.fldPriorityCode asc


Results:

PriorityCalls
120
22912
3152
4571
54
Total3659


I would like to transfer these results to an excel sheet. For instance when the user opens up the excel worksheet and types in for a example a start date: 01-01-2007 and an end date: 03-05-2007 (into textboxes) then clicks a button say called 'Get stats' and then the results appear on the sheet.


How can this be done?

View Replies !   View Related
DTS To Create New Excel Sheet In Existing Workbook
Has anyone been able to create a DTS that will create a new sheet within an existing Excel file. I want one Excel file with multiple tabs referencing the beginning of each week and growing. The name needs to be dynamic so as to not overwrite previous sheets (tabs) in the file.

I have a current ActiveX script that will move the data to a dynamic name (date), I just can't create the table (sheet/tab) to move the data to.

Any help would be appreciated.

-Mark

View Replies !   View Related
Empty Rows In Excel Data Sheet Used In DTS
Hi Everyone,

I am using a DTS package where one of the inputs is an Excel Sheet. Actually this sheet is updated manually whenever required i.e once a week or sometimes once a month, but the DTS package runs everyday.

Whenever new rows are added or deleted manually in the excel sheet, empty rows are showed in the sheet after the last row of data. This hinders the DTS package, because the destination table to which the data in the Excel sheet is sent has Primary keys in it.

Can anyone suggest me how to avoid getting the empty spaces in the excel sheet.

Thanks in advance.

Regards,
kalyan

View Replies !   View Related
Update Table From Linked Excel Sheet
I cant seem to reference columns within a linked Excel server
using MS SQL express

Code:

UPDATE dbo.Items
SET CCC=XL_SERVER.CCC
FROM XL_SERVER...sheet1$
WHERE BBB LIKE '7%'

i.e I want to update column CCC in my Items table from an Excel table column CCC where column BBB begins with 7

I have set up XL_SERVER correctly.

Help!

View Replies !   View Related
Need Some Advise On Loading Data From Excel Sheet
I insert/update thousands of line items daily to my MS SQL 2k db each day from multiple excel sheets that are uploaded. In Microsoft's infinite wisdom Excel and MS SQL is not "Fully" compatible and some characters throw off the uploads, cause errors in loading, etc. Each Excel sheet has from a few rows up to 50,000 rows or more. We load around 100 of these Excel sheets each day depending on what our users upload.

Our main problem appears to be with "Special Characters", anything that is not a number or letter seems to be an issue in loads. We have written our scripts to ignore a certain set of characters such as #,!, -, ', ", [, ], {, }, +, =, *, %, ~, `, <,>, etc. But we still get errors. This has become a frustrating nightmare. Any help in the right direction would be greatly appreciated.


I have tried ASP scripts, VB created exe's, converting the Excel sheet to a text file, then uploading, and other various means to get this process error free. Some files never have issues loading, some excel files will error out and not at the same point each time. We can run the same file 5 times in a row and it will stop/error at a different point each time without any rhyme or reason.

Now we are not just doing an "Insert", there are several variables that are at work when loading the data, like combining exact items into one row, associating data with ID's in another table, etc. It is not just a simple, take this data and place it here scenerio which makes this a serious headache to figure out how to make this error free and troubleshoot.

Is there some information or a direction I should look to consider a solid solution to importing data from Excel sheets to a MS SQL 2k db? These files are loaded into a specific folder and on upload they are also recorded in a table marked ready for update in the db. Our scheduler runs the exe associated with that users ID and loads their data, overwriting their previous data load, then marks the file as done.

Is there a proven method, some external program that can be used to make this a solid process, or any direction you can provide for me to research?

View Replies !   View Related
Transfer SQL Data Results To Excel Sheet
Code:

-- (1) Number of calls received for each priority of call [for a specified date range]

declare @startdate datetime,
@finishdate datetime

select RM.fldPriorityCode as 'Priority',
count(RM.fldRequestID) as 'Calls'
from tblRequestMaster RM
where RM.fldPriorityCode between 1 and 5
and RM.fldRequestDate between '01-01-2007' and '03-05-2007'
and RM.fldRequestFlag like 'D'
group by RM.fldPriorityCode
union
select
'Total' as 'Priority',
count(RM.fldRequestID) as 'Calls'
from tblRequestMaster RM
where RM.fldPriorityCode between 1 and 5
and RM.fldRequestDate between '01-01-2007' and '03-05-2007'
and RM.fldRequestFlag like 'D'
order by RM.fldPriorityCode asc


Results:

PriorityCalls
120
22912
3152
4571
54
Total3659




I would like to transfer these results to an excel sheet. For instance when the user opens up the excel worksheet and types in for a example a start date: 01-01-2007 and an end date: 03-05-2007 (into textboxes) then clicks a button say called 'Get stats' and then the results appear on the sheet.


How can this be done?

View Replies !   View Related
Writing Data In To Excel Spread Sheet
Hi All,

Here is the scenario:

I am inserting data into a spread sheet from user interface(power builder). But at the same time some one can open that excel spread sheet to read the data. Then the process was going to fail(it won't able to write the data in to the spread sheet). How to avoid this situation? I really appreciate if anyone can shed some light.

Thanks in advance!!

View Replies !   View Related
Exporting Excel Sheet To Sql Server Table
Hi All ,

I am new to Sql Server and all the DBA stuff. My boss wants me to export a folder containing excel sheet data to sql server table . To be more precise , he wants to automate the DTS process where instead of exporting each and individual worksheet to the DB , he wants me to maintain a separate folder of these sheets and export that folder.

Please do lemme know , how do I do this .

Thanks,
Aparna

View Replies !   View Related
Exporting Data From Excel Sheet To Db Table
i have to export the data from excel sheet to database table. for that i created linked server in sql 2000. after creating i get the SQLOLEDB error when i expand the linked server in enterprise manager.Can anyone help me in solving this issue.

View Replies !   View Related
Import Excel Data Sheet To SQL Table - How To ??
I need to make a script in SQL 2005 to import data from an Excel sheet into a SQL table.
I am using the wizard to import now.
Import from Excel 2000. First row of the excel sheet has column names.
Excel file name is: EXL.xls, sheet name is: Sheet1
Destination sql database name is: NM, table name is: Sht1
I use SQL Server Authentication to access the database.
User name: ABC and password: DEF
Database name is: DB
I am using the following setting when importing now:
- Delete rows in destination table
- Enable identity insert

View Replies !   View Related
Hw To Import Data From Excel Sheet To Sql Server
Hello All,

Can any one tell me how to import data from excel sheet to sql server 2005?

I have made table ready bt i dont know what i have to do for the above purpose.

Thanks
Prashant Hirani

View Replies !   View Related
Select Query Result In Excel Sheet
hi all
how can i put select query result in excel sheet.
can any one help me

Regards
js.reddy

View Replies !   View Related
Import Data From Excel Sheet Dynamically.
Hi,

Curently I am using a DTS package which is used to import data from Excel sheet into sql dollar table.

Now, the no. of Excel sheets is more than one and everytime the DTS package and VB Code has to be updated and sql dollar tables has to be increased to the no. of Excel sheets available.

The DTS package being executed by VB Code(.EXE).

How can I modify the DTS package and VB Code so that the import can be done dynamically irrespective of no. of Excel Sheets.

If anybody have a solution for this ,

Kindly let me know.

Regards,
Srinivas Alwala

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved