Transfer data from any mdb file to sql server?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: robeito <robeito@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 15 Apr 2009 10:04:04 -0700

Hello everybody

I must develop an application to transfer data from mdb file to an sql
server database.

The input mdb file is selectable by the user (all the mdbs have identical
tables)

The target database is always the same

The easiest way for me would be to have links in my application pointing to
the selected mdb tables, and links pointing to the sql tables. And then do
the transfer

Any idea about this?
Shall I try an adp project?

.

Prev by Date: Re: Linking tables access - sql server 2005
Next by Date: Can't create persistent ## tables with ADP call to a stored procedure (!?)
Previous by thread: Linking tables access - sql server 2005
Next by thread: Can't create persistent ## tables with ADP call to a stored procedure (!?)
Index(es):
- Date
- Thread

Relevant Pages

Access import to SQL Server with DTS
... I am trying to import an Access mdb file with DTS into SQL Server ... Is there another way to transfer data from Access to SQL without ...
(microsoft.public.sqlserver.dts)
Transfer data from any mdb file to sql server?
... I must develop an application to transfer data from mdb file to an sql ... server database. ... The input mdb file is selectable by the user (all the mdbs have identical ...
(microsoft.public.access.modulesdaovba)
Transfer data from any mdb file to sql server?
... I must develop an application to transfer data from mdb file to an sql ... server database. ... The input mdb file is selectable by the user (all the mdbs have identical ...
(microsoft.public.access.externaldata)
Re: Need help to put a DB in Web
... I thank you for the great guides.Specially for the sql example.I will never ... I know u recommend SQL server for our Web DB.But knowing that our main ... >> is a special characteristic of CANHOST web provider. ... > Remember, the public Joe user cannot connect, or see the mdb file. ...
(microsoft.public.access.formscoding)
Re: SBS 2008 + Multi User Microsoft Access DB
... have SBS 2008, download, if you don't already have it, one of the free versions of MS SQL and install it - convert the Access DB to MS SQL and use MS SQL, your problems will be gone. ... It may be a DESKTOP database but tell THAT to my vendors. ... And while a multi-user LOB application doesn't actually have to be split between a user interface .mdb file, containing forms, reports etc., and a database .mdb file, this is the customary way to do things for a number of reasons. ... Doing so removes the largest risk with networked Access, that of the fragile data file being corrupted by a disconnection. ...
(microsoft.public.windows.server.sbs)