[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

>MDB to Sql Server 2000 Conversion

Hi,

Can anybody Help me on Dumping .MDB file to Sql Server. I need to write Import for this dump. Also I have more than 100 .MDB file , so can we specify the path and file name dynamically so that all these files can be imported.

Your help is very much appreciated.

Thanks,
Shruti
0
amiteshsinha
Asked:
amiteshsinha
  • 2
  • 2
  • 2
  • +1
1 Solution
 
Arthur_WoodCommented:
you can use the SQL Server Upsize wizard that is built into Access.  Open the MDB, click on Tools/Database Utilities/Upsizing Wizard   and then follow the instructions.

AW
0
 
CarlWarnerCommented:
ACC: "Upsizing to Microsoft SQL Server" White Paper Available in Download Center
http://support.microsoft.com/default.aspx?scid=kb;en-us;175619
0
 
arbertCommented:
Are the structures the same?  If you really don't need to keep any existing Access forms or reports, then DTS might be a better option than the upsizing wizard--especially if all the formats are the same, you can just change the data source names on the DTS input and import the next MDB file...
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Arthur_WoodCommented:
I do not understand.  You say you have 100 separate MDB files?  why such a large number, and as arbert has asked, are they ALL the same strcuture (the sames tables, with the same fields in each table)?

perhaps you can desribe a bit of what these MANY mdb files represent?

AW
0
 
amiteshsinhaAuthor Commented:
Hi ,
Thanks,
Actually they are same structure files. My client had Access for its accounting purpose, but they were saving data for every entity in seperate folder and seperate .MDB file. They have 100 such entities.
I want to import one MDB file and update few columns and then import next MDB.

So I was trying to write an ActiveX which can do these steps. So I want to know what is the best approche?
Thanx, Shruti
0
 
arbertCommented:
I would setup a DTS package then.  You can code ActiveX to loop through and change the file names to automatically process each file though.

Brett
0
 
amiteshsinhaAuthor Commented:
Hi,

Yup, I think that is in only easiest solution I see.

I am sure I can do it now.
This will run my Data migration smooth.

Thanks Arbert and everybody for help.
Shruti
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now