LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default How to CONCATENATE 50 fields in Excel table into SQL Insert State

Excel 2003 SP3 on Windows XP SP2

I have problem when trying to construct an SQL Insert statement using the
CONCATENATE function in Excel. There are over 50 fields.

I would like to construct an SQL insert statement from tables stored in
Excel to be used to populate tables in a SQL database. Using the CONCATENATE
function below I ends up with a complete SQL insert statement

=CONCATENATE("INSERT INTO Product (Field1,Field2,Field3,Field4,Field5)
VALUES ('",B2,"','",C2,"',",D2,",",E2,",",F2,")")

When I try to do the same for a large table ( 50 fields). I have the
following error in Excel ("The formula you typed contains an error").
Reading through the forum Excel sees to have a limit of 30 strings for the
CONCATENATE function.

However, the concatenate function only allow me to enter 14 fields. There
seems to be some sort of limits in total characters within concatenate
function (when I shorten some of the field names i.e. to F1, F2, F3 I could
enter more fields)

Please could you advice how I could maybe do multiple CONCATENATE. For
example, concatenate the first 30 strings, then concatenate the result of
that with the remaining 20 strings, etc?

Many thanks in advance,

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I show state-by-state data (as silos) on a map of NA Rob Charts and Charting in Excel 0 November 5th 07 03:41 PM
Cannot Concatenate fields using Query CJ Excel Discussion (Misc queries) 6 September 10th 07 04:32 AM
Converting State Names to State Abbreviations aznate Excel Discussion (Misc queries) 1 October 20th 06 06:52 AM
How do I insert new fields in Excel DB created using template wiza SHARIEEH Excel Discussion (Misc queries) 0 May 3rd 06 06:55 PM
number of fields in the row fields in pivot table UT Excel Discussion (Misc queries) 0 April 13th 06 01:17 AM


All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"