This code will dynamically create an Insert SQL query for a database. It also teaches some things like how to create a database and table though code, how to use the ADOX library, data formatting and etc...just look at the code, to much to write. Requires ADO 2.5 and was created with VB6 SP4. Not tested on anything else. Reasonably good commenting, should be easy to understand.