sp_addlinkedserver N'Excel', N'Jet 4.0', N'Microsoft.Jet.OLEDB.4.0', N'D:\Data\ProductData.xls', NULL, N'Excel 5.0' if exists (select * from sysobjects where id = object_id(N'[dbo].[temp_product_working_table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[temp_product_working_table] CREATE TABLE [dbo].[temp_product_working_table] ( [Product_ID] [int] NULL , [Product_Name] [varchar] (100) NULL , [Customer_Lastname] [varchar] (50) NULL , [Customer_Firstname] [varchar] (30) NULL , [Customer_Phone] [varchar] (25) NULL , [Customer_Email] [varchar] (100) NULL , [Customer_Adr1] [varchar] (50) NULL , [Customer_Adr2] [varchar] (50) NULL , [Customer_City] [varchar] (100) NULL , [Customer_State] [char] (2) NULL , [Customer_Zip] [varchar] (10) NULL ) Insert Into temp_product_working_table ( Product_ID, Product_Name, Customer_Lastname, Customer_Firstname, Customer_Phone, Customer_Email, Customer_Adr1, Customer_Adr2, Customer_City, Customer_State, Customer_Zip ) Values ( #DataArray[1]#, '#DataArray[2]#', '#DataArray[3]#', '#DataArray[4]#', '#DataArray[5]#', '#DataArray[6]#', '#DataArray[7]#', '#DataArray[8]#', '#DataArray[9]#', '#DataArray[10]#', '#DataArray[11]#' ) [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => AZDeveloper [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [attachments] => [allattachments] => ) -->