Post reply

Out of String Space

  • May 2, 2016 at 1:07 pm

    #307065

    Running VBA code to join access tables into one SQL table.

    If Not IsNull(info(x)) And info(x) <> "" Then

    join = join & info(x).Name & ": " & CStr(info(x).Value) & "{P}"

    Else

    join = join & info(x).Name & ": Not Reported{P}"

    End if

    Any ideas what is going wrong. The error is occurring on the underlined code.

  • May 2, 2016 at 5:13 pm

    #1876129

    I can't answer this but would suggest moving the Access to SQL Server. Then joins get much easier.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply