Outputting a table using VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a string such as "2005082408000001~worksclock~XX2005082413000002"
I have a VBA module that will parse the information into a readable string
for the user. I want to put these values into a table using the other
information passed into the module and then append a table for each row. Is
there any way to make a table out of information in the VBA functions?
 
Hi,
you can use Insert query to do so:

currentdb.execute "Insert Into MyTable (Field1, Field2, Field3) Values ('" &
aa & "','" & bb & "','" & cc & "')"

where aa, bb, cc are variable with parsed information
 
Back
Top