OOTP Developments Forums - View Single Post

jnoblehall · 07-10-2003, 12:13 PM

First gotta say I love the exporter!

Is there a quicker way to get the CSV's into access tables?

Right now, I go table by table, delete the data and import new data so I can preserve my queries and reports. I toyed with the idea of writing a macro or something to get them all in there, but That means I would have to learn how to use VB. Does anyone know a quicker way to do this?

TIA

07-10-2003, 12:13 PM	#1
jnoblehall Registered User Join Date: Jul 2002 Location: Arizona Posts: 26	Using Commishjoe'e exporter for Access First gotta say I love the exporter! Is there a quicker way to get the CSV's into access tables? Right now, I go table by table, delete the data and import new data so I can preserve my queries and reports. I toyed with the idea of writing a macro or something to get them all in there, but That means I would have to learn how to use VB. Does anyone know a quicker way to do this? TIA