Still the issue exists

I think I am confusing. So, if we have more data, we get more pages...and vice versa right...So, at this point i think it is good to focus on only...

Reduce page count

So, if the table has more than 1000 pages, so how can we reduce it.

I tried to run these script individually and able to load the data. But, have to see how to create a variable, where it takes table name. But, if we...

--Tried this atleast to enter the table name, but receiving an error, of incorrect syntax,...

create proc Up_Export

(

@Tablename as varchar(20) = null

)

AS

SET NOCOUNT ON

begin

INSERT INTO @Tablename --Receiving error over here,...

I tried this..but receiving the following errors:

create proc up_exportdata

as

begin

IF EXISTS (SELECT 1

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE='BASE TABLE'

...

Error:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.".

Msg 7321, Level 16, State 2, Line 5

An error occurred while...

Tried this script, but didn't worked..can u help out plz..

Declare @Tabname nvarchar(100)

set @Tabname = 'C:\..\...\packages\*.xls' --Given path of the folder

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\..\...\packages\@Tabname.xls', '@Tabname')

This query looks good. But, if we have 100 tables in a folder, do we need to keep change the table name, pathname for all 100 tables manually?

ok..thank you...

I am actually working on moving a 3rd party company database to my environment. Initially they have give there DB in last january, now they made few more changes...

There is NO auditing on this database.

Thanks All. It is not the database upgrade. It is only the data upgrade. As the company has modified it, so I need to make those changes into my existing...

Will do thanx mike

It works!!! Thanks for quick response.