Prev: Database Collation Change - Unusably slow Import/Export Wizard
Next: buffer latch 2 timeout error when connectiong to db from mgmt stud
From: Tazzin on 21 Jun 2010 15:41
To bypass the limitation of the use the & sign instead of using
=Concatenate... i.e.
=CONCATENATE(A1,A2,A3...)

is the same as

=A1&A2&A3

with this, you bypass the limitation of the "50 Fields" you are
encountering.. I know this late (by 2 yrs) but if anyone elses searches for
this hopefully this will help ;)..

"will~" wrote:

> SQL Server 2005, Excel 2003
>
> I would like to populate some tables in a SQL database from some tables in
> Excel.
> Previously I have used the Concatenate function in Excel to construct SQL
> Insert statement such as example below.
>
> =CONCATENATE("INSERT INTO Product (Field1,Field2,Field3,Field4,Field5)
> VALUES ('",B2,"','",C2,"',",D2,",",E2,",",F2,")")
>
> However, there is a limit in using the Concatenate function in Excel and
> this dows not work on a larger table (50 fileds). Please could you advice
> how I could create the SQL insert statements using this Excel table to
> populate the associate SQL table? Is there any better/alternative ways?
>
> Many thanks in advance,
>
 | 
Pages: 1
Prev: Database Collation Change - Unusably slow Import/Export Wizard
Next: buffer latch 2 timeout error when connectiong to db from mgmt stud