April 13, 2012 at 5:59 am
HI all
Could you please give me suggestion how to import data from XL(office 2007) file to SQL Server 2008r2.
Please remember do't use any SSIS package Or wizards. I want only Querry.
Regards
Naresh Reddy
April 13, 2012 at 6:58 am
This was removed by the editor as SPAM
April 14, 2012 at 12:52 am
Hi,
It is possible to take database with differential backup .
First i have normal backup file, then i will create one table at the same database after i will take differential backup and then i restore database at that time i want new database means with newly created table.
Please tell me which one is the best way to get proper data.i have been trying to restore differential ( .bak ) backup file but i didn't get new data.
Regards
Naresh Reddy
April 16, 2012 at 1:49 am
This was removed by the editor as SPAM
April 16, 2012 at 1:13 pm
Have a look at this thread and the issues i had importing from Excel 2007 on 64 bit
http://www.sqlservercentral.com/Forums/Topic1275171-391-1.aspx#bm1281939
***The first step is always the hardest *******
April 18, 2012 at 10:32 pm
Hi ALL
how to write a procedure for create update delete to dinamically.
Means If i execute the procedure like this
EXEC PROCEDURE name @parameter,tablename
the above parameter have three statements.
Like
if i pass the @parameter=update
at that time i want to create update procedure.
If i pass the @parameter=insert
at that time i want to insert procedure
if i pass the @parameter=delete
at that time i want to delete table procedure .
please send me as soon as possible
it is very need full and urgent to me.
Regards
Naresh reddy
April 19, 2012 at 3:48 pm
For the record BULK INSERT and bcp will not import Excel files (xls or xlsx files in binary format). Those tools are meant for importing plain-text files.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply