Hello comunity

Nobody have an idea ???

Luis Santos

Many thanks for all your replies, they works ok

Luis Santos

Hello Comunity

I´am curious about this kind of method to import into SQL 2005 an Excel Sheet.

I try this script :

INSERT INTO dbo.st

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

'Excel 8.0;Database=C:\test.xls', [sheet1$]) ...

Hello Brian

Ok, i agree with you, but you did not answer to my question and i have the same doubt.

Andras give me an example , my unique question is to...

Many thanks for your reply.

In fact i have an application Client/server , the Client is build in VFP and BD is SQLSRVER.

i pretend for example when my invoice document have...

Hello comunity

Thanks for all yours replies and interest. i will try all your suggestions

Many thanks

Luis Santos

Hello Jeff

I hold many lines because i want to return for each u_subconta (account of Customer) all the movment of this account.But i thinks that is not the problem.

My problem...

Hello Adam

I test your last reply , in this moment the problem exist when the field u_subconta change, in this case the RunningTotal must reset to zero, because it´s an...

Hello again Adam

sorry, but i test your script and for that i simplify my TSQL like that :

SELECT min(a.conta) as [Conta], min(a.u_subconta) as [subconta], min(a.data) as [Date], min(a.dinome)as [diario],min(a.adoc)...

Hello Adam

Many thanks again for your useful help and interest.

I will try your advise

Thank you

Luis Santos

Hello Adam

Thanks for your reply, in fact is exactly what i need.

But you use a Temp table, can i use your example with the following TSQL script.Could you give me...

Hello Ramesh

Thanks for your reply, but to search on site do you have an ideia.....!

Also, if anyone give me the solution, i thinks it´s difficult an existing Post regarding my...

Hello again Matt

Sorry, if i send you this post , but i send to you a private message and i know if you will receive them, so i attache the...

Hello Jeff

Thanks for your reply, when i say "Depending if is bissextile year or not", it´s because February could be have 28 days or less depending on the year.

How can...

Hello again

Someone have an ideia regarding my last post, about where in this script i can place an INSERT or UPDATE Query depending if the article exit or not on...