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]]

Re: Adding fields in SQL database

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" <reidar@eivon.n o> escribió en el mensaje
news:eRn1Ysk2FH A.896@TK2MSFTNG P09.phx.gbl...[color=blue]
>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
>
>
>
>[/color]