Running SQL in VB

[TKnight]

Hi, is there any way that you can run more than 256 characters of SQL in VB? I read that using the DoCmd.RunSQL method this is the maximum number of characters you can use and it doesn't get you very far... Thanks, Tom

 

[AncientOne]

The maximum length of the sqlstatement argument is 32,768 characters (unlike the SQL Statement action argument in the Macro window, whose maximum length is 256 characters).

 

[TKnight]

Thanks mate, a small oversight on my part! I reckon 32,000 odd characters should do me.... )
Tom.