Ok...Looked around and haven't been able to find what I'm looking for on this, so hope you guys can help me out. I am trying to automate some of the tedious task within a report.
I need to connect to a mysql server every day and create links to the newest tables in Access and then do an append to my main table with that data (i could forego the link and just append the data in the new table, but not sure how to do that). From what I can tell I need an ADO connection to the database where the tables are housed (which I'm fairly new to), how would the code look to just import the new table and not every table in there everyday (they are date stamped at the end of the table name which should help)?
So basically what I'm looking for is a sample of code to
1) How to make the connection to the mysql table, as well as how to disconnect from it. I was reading over how to create ADO Disconnected recordset and attempted to set it up this way, but it didn't appear to work (maybe cause I didn't have a task for it to do when it got there though)
2) What would the code look like to import this data from table "...061908" (on 06/20/08)?
Somebody also recommended I could set this up with a simple SQL Statement as well...if that sounds like a better idea then what would that look like as well?
Feel free to ask if I didn't provide enough information and Thanks in advance!
I need to connect to a mysql server every day and create links to the newest tables in Access and then do an append to my main table with that data (i could forego the link and just append the data in the new table, but not sure how to do that). From what I can tell I need an ADO connection to the database where the tables are housed (which I'm fairly new to), how would the code look to just import the new table and not every table in there everyday (they are date stamped at the end of the table name which should help)?
So basically what I'm looking for is a sample of code to
1) How to make the connection to the mysql table, as well as how to disconnect from it. I was reading over how to create ADO Disconnected recordset and attempted to set it up this way, but it didn't appear to work (maybe cause I didn't have a task for it to do when it got there though)
2) What would the code look like to import this data from table "...061908" (on 06/20/08)?
Somebody also recommended I could set this up with a simple SQL Statement as well...if that sounds like a better idea then what would that look like as well?
Feel free to ask if I didn't provide enough information and Thanks in advance!