Prev: Opening index automatically
Next: VOPP DBF Utility
From: Paulo Oliveira on 8 Apr 2010 12:17
Hi all,

Until now, i have a mechanism to export a Sql table to Excel, but now
i need import some lines from excel file to a Sql table.
Any idea, please?

TIA
Paulo Oliveira
From: dlzc on 8 Apr 2010 12:35
Dear Paulo Oliveira:

On Apr 8, 9:17 am, Paulo Oliveira <pa...(a)clipinfor.com> wrote:
> Hi all,
>
> Until now, i have a mechanism to export a Sql
> table to Excel, but now i need import some
> lines from excel file to a Sql table.
> Any idea, please?

Some people have had good success (as in fast) using OLE to copy the
rows to the clipboard, and then write code to parse them and update
the table.

David A. Smith
From: Paulo Oliveira on 8 Apr 2010 12:39
David,

In my office i do that all the time :)
But i need a VO mechanism to implement in my app for my clients do the
job.

Paulo

On Apr 8, 5:35 pm, dlzc <dl...(a)cox.net> wrote:
> Dear Paulo Oliveira:
>
> On Apr 8, 9:17 am, Paulo Oliveira <pa...(a)clipinfor.com> wrote:
>
> > Hi all,
>
> > Until now, i have a mechanism to export a Sql
> > table to Excel, but now i need import some
> > lines from excel file to a Sql table.
> > Any idea, please?
>
> Some people have had good success (as in fast) using OLE to copy the
> rows to the clipboard, and then write code to parse them and update
> the table.
>
> David A. Smith

From: Jamal on 8 Apr 2010 12:43
Paul,

See: http://support.microsoft.com/kb/321686

Jamal


"Paulo Oliveira" <paulo(a)clipinfor.com> wrote in message
news:5a770f97-5a9a-48b2-9f2c-b0c17249cf3b(a)z7g2000yqb.googlegroups.com...
> Hi all,
>
> Until now, i have a mechanism to export a Sql table to Excel, but now
> i need import some lines from excel file to a Sql table.
> Any idea, please?
>
> TIA
> Paulo Oliveira

From: Paulo Oliveira on 8 Apr 2010 13:24
Jamal,

Thanks for the tip...

I create a Linked server and just work fine for my propose.

SELECT * INTO XLImport FROM EXCELLINK...[VO356$]



On Apr 8, 5:43 pm, "Jamal" <vodotnet_nos...(a)yahoo.com> wrote:
> Paul,
>
> See:http://support.microsoft.com/kb/321686
>
> Jamal
>
> "Paulo Oliveira" <pa...(a)clipinfor.com> wrote in message
>
> news:5a770f97-5a9a-48b2-9f2c-b0c17249cf3b(a)z7g2000yqb.googlegroups.com...
>
> > Hi all,
>
> > Until now, i have a mechanism to export a Sql table to Excel, but now
> > i need import some lines from excel file to a Sql table.
> > Any idea, please?
>
> > TIA
> > Paulo Oliveira
>
>

 |  Next  |  Last
Pages: 1 2
Prev: Opening index automatically
Next: VOPP DBF Utility