Adding fields in SQL database

[reidarT]

I have Access databases located on several offices.
Ever day or once a week they need to add records from a table to a
sql-database on the internet.
I am not sure how to do this upload.
1. I can make a file uplaod and then make an import routine on the
sql-server
2. Add the fields directly into the sql-database.
Any suggestions?
reidarT

 

[Carlos J. Quintero [VB MVP]]

See if you can use the Replication services of SQL Server:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replover_694n.asp

--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com