Board index MS SQL Server

importing data from Access 97 databases in remote sites

importing data from Access 97 databases in remote sites

Post by David Thoma » Tue, 23 Jan 2001 17:17:20



I am new to SQL server and I am hoping that it will allow me to import
  data from Access97 databases located in 6 different places in the county.
  When the project is running full blast those Access databases will be
  generating 4-5 million records weekly so I will also have to be deleting
  the data after I have verified that it has transferred correctly so that the
  Access databases don't get too large. The Access databases are located
  on NT4 computers connected to the SQL server over T1 lines running
  TCP/IP. What would be the best procedure (and command) to import
  the data? Is there a way to delete the data on the remote servers? And
  finally, can I automate this whole process to happen weekly?
 
 
 
Top

1. remote access over 33.6 to access 97 database

waht are the size limitations before the database is "unuseable over RAS?

i get error when trying to ras into an access database.

has anyone ever sucessfully accomplished this?

thanks, will


2. CORRECTION TO Position in Tucson

3. Access '97 Database on an ftp site

4. Delphi 2.0 X Access (mdb)

5. Import Access 97 data into SQL Server 6.5 using Transac-SQL

6. latest version list?

7. Data import from Access 97 into SQL-Server 7.0

8. Two questions about Visual C++

9. Access 97 TransferDatabase method to import queried SQL 2000 data

10. Import & Replace Data in access 97

11. bulk data import from Oracle into Access 97

12. Import Excel data into a BD Access 97 wiyh Visula Basic 5.0

13. Importing Btrieve 7 data on local HD to MS Access 97


All times are UTC
Board index