Import multiple MDB files

From: Don (dons100_at_ameritech.net)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 03:22:10 GMT

Hello,

I have multiiple MDB files to move into SQL Server
2000. What is the best way to import these files? I want to keep checking
a certain network
folder to see if a new MDB exists. If so, I'll move it into the SQL Server,
then move the MDB file to a subfolder, then I'll check to see if any other
MDB files exist on the network folder.

Thanks

Don

Relevant Pages

  • Re: Uploading Access database
    ... You can (if you remove .mdb files from the list of non-allowed files) add a ... I.e. SQL Server can handle converting this file into a blob/image for ... The problems come if you use the database from WSS. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: DTS Examples of moving data from Access to SQL Server
    ... >I'm going to use a DTS package to move multiple MDB files into SQL Server ... Is there anywere that has good example of different parts of DTS ... If so, I'll move it into the SQL Server, ...
    (microsoft.public.sqlserver.dts)
  • Re: Search multiple MS Access database files via asp.net web application
    ... Instead of having 10,000 individual mdb's, you need to consolidate your ... Access, being a desktop database system, ... like Sql Server - where one Sql Server database alone can store a ... I am assuming each of the 10,000 mdb files is pretty ...
    (comp.databases.ms-access)
  • "There isnt enough memory" error
    ... and back ends are MDB files, so no SQL Server involved here. ... dynamically hidden based on the contents of a recordset, ... Only one of the reports has a graphic on it (a linked bmp, ...
    (microsoft.public.access.reports)
  • Swapping DBs
    ... ..mdb files and send them to other users ... I have been reading that with SQL Server Express, you can treat databases ... we can not use SQL Server Express because it doesn't support ...
    (microsoft.public.sqlserver.msde)
Loading