Re: Upload Access Data to Web

Paul,

That is one possibility but I don't know yet because we are in the process of
a complete website redesign and the new sql server database hasn't been setup
yet.

Maybe I should be asking a different question: What would be the ideal way
to set up a connection between the Access Database and Sql Server? That
Access Database already exist but since the Sql Server Database hasn't been
setup yet I can dictate how that gets done.

Thanks Again!
Dustin

Paul Clement wrote:
¤ Paul,
¤
¤ Basically I would need to upload data from an Access Database Table on a
¤ local server to a sql table on a web server.
¤
¤ Thanks,
¤ Dustin

Can you create a "linked" table in your Access database (File...Get External Data...Link Tables) to
the SQL Server table you will be uploading to?

Paul
~~~~
Microsoft MVP (Visual Basic)

--
Message posted via VBMonster.com
http://www.vbmonster.com/Uwe/Forums.aspx/vbasic-com/200701/1

.

Relevant Pages

  • Re: Copy database schema from Access to SQL Server
    ... It can import a JET database in a single stroke. ... Hitchhiker's Guide to Visual Studio and SQL Server ... ¤ projects to SQL Server, ... schema and then use DDL code to create the corresponding objects in SQL Server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Failure of Linked table in Access...
    ... SQL Server database via an ODBC DSN. ... in the Access database with various forms and reports. ... error and all subsequent queries on the PROJ table fail. ... The table is one of many tables that are linked from SQL Server ...
    (microsoft.public.access.modulesdaovba)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Help! Microsoft Access 2003 issue with linked tables.
    ... I have a Microsoft Access database and tables are linked to the SQL Server ... I use that SQL user in my connection string, ...
    (microsoft.public.access.security)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
Loading