Solved

>MDB to Sql Server 2000 Conversion

Posted on 2004-04-19
9
306 Views
Last Modified: 2012-06-21
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
Comment
Question by:amiteshsinha
  • 2
  • 2
  • 2
  • +1
9 Comments
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 10863001
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
 
LVL 33

Expert Comment

by:CarlWarner
ID: 10864253
ACC: "Upsizing to Microsoft SQL Server" White Paper Available in Download Center
http://support.microsoft.com/default.aspx?scid=kb;en-us;175619
0
 
LVL 34

Expert Comment

by:arbert
ID: 10865494
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 10865699
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
 

Author Comment

by:amiteshsinha
ID: 10868790
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
 
LVL 34

Accepted Solution

by:
arbert earned 125 total points
ID: 10869270
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
 

Author Comment

by:amiteshsinha
ID: 10870341
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MySQL 5.6 or MariaDB 15 73
Folder Replication 4 45
#deleted rowsc access 2010 backend 4 33
What does "flush tables;" do exactly? 7 47
I guess that all of us know that caching the data usually increase the performance, but I worried if all of us are aware about the risk that caching the data provides and how to minimize this.  That’s the reason why I decided to write this short art…
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now