VB beginner needs help

VB beginner needs help

• Peter Winson

  Hi,

  Your welcome.

  Please mark my 1st post AS ANSWER then....if you wish.

  Regards,

  S_DS

  
  
  

• Pragmented

  That works! Thanks much spidy darkside.
  

• reichard

  Hi,

  Try.>>

   

  Dim t As String

  Dim s As String

  t = CStr(Dts.Variables("TableName").Value)

  s = "CREATE TABLE Promohist2.dbo." & t & "" & _

  [FirstName] char (10) NULL,[MiddleName] char (40) NULL,[LastName] char (40)NULL)"

   

  Dts.Variables("SQLText").Value = s

  Dts.TaskResult = Dts.Results.Success

  End Sub

   

   

   

  See these url links for more on access sql or mdb database stuff.>>

  http://forums.microsoft.com/MSDN/Search/Search.aspx words=sql&localechoice=9&SiteID=1&searchscope=forumgroupscope&ForumGroupID=10

   

   

  http://forums.microsoft.com/MSDN/Search/Search.aspx words=access&searchKey=&lcid=1033&searchscope=forumgroupscope&siteid=1&ForumID=-1&ForumGroupID=10

   

   

  http://forums.microsoft.com/MSDN/Search/Search.aspx words=mdb&searchKey=&lcid=1033&searchscope=forumgroupscope&siteid=1&ForumID=-1&ForumGroupID=10&GoButton=+Go+

   

   

  Use & to join strings not the plus. You can also use a space then the underscore like >> _

  to continue a line as i have above.

   

  Regards,

  S_DS

   

  
  
  
• VB beginner needs help