combine data base
Posted: Thu Mar 20, 2008 5:17 pm
Hey guys,
I have several access database that I wanted to combine into one big database (for taxes related stuff) and I'm having problems.
What I did is to export all the hands from every single database onto txt files....took few hours, but no problem with that!! but when I'm trying to import back all those txt files into the new sql data base, it says that I'm selecting to many files, so I made several test and it seems like you can only import about 15-20 .txt files at a time... whats the problem then? I have about 10 000 files to import ... i dont have that much pascience.
is there an other way to combine all my database together ?? hard or easy way I have to do it!!
oh I'm talking about PT2 access db to PT2 sql db (obv because it's to big)
thanks so much and keep up the good work for pt3 !!
I have several access database that I wanted to combine into one big database (for taxes related stuff) and I'm having problems.
What I did is to export all the hands from every single database onto txt files....took few hours, but no problem with that!! but when I'm trying to import back all those txt files into the new sql data base, it says that I'm selecting to many files, so I made several test and it seems like you can only import about 15-20 .txt files at a time... whats the problem then? I have about 10 000 files to import ... i dont have that much pascience.
is there an other way to combine all my database together ?? hard or easy way I have to do it!!
oh I'm talking about PT2 access db to PT2 sql db (obv because it's to big)
thanks so much and keep up the good work for pt3 !!