By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 733 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

Adding fields in SQL database

P: n/a
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


Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
See if you can use the Replication services of SQL Server:

http://msdn.microsoft.com/library/de...lover_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

"reidarT" <re****@eivon.no> escribió en el mensaje
news:eR*************@TK2MSFTNGP09.phx.gbl...
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

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.