Getting To SQL Dump into MS Access

munstermash · 07-06-2007, 12:43 PM

Is there a way to bring all the dump files into a ms access database?

Comedian2004 · 08-14-2007, 09:57 AM

You can easily manually do it.

Create a new database in access. Import the CSV file into a new table. You will then have to set up the relations between each field. It is very time consuming.

I am currently working on a program to automate this process. Sure is not easy.

07-06-2007, 12:43 PM	#1 (permalink)
munstermash Minors (Single A) Join Date: May 2002 Posts: 57	Getting The SQL Dump into MS Access Is there a way to bring all the dump files into a ms access database? Last edited by munstermash : 07-06-2007 at 05:15 PM. Reason: wrong title

08-14-2007, 09:57 AM	#2 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,340	You can easily manually do it. Create a new database in access. Import the CSV file into a new table. You will then have to set up the relations between each field. It is very time consuming. I am currently working on a program to automate this process. Sure is not easy. __________________ Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode