Results 1 to 3 of 3
  1. #1
    Manotosh is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2011
    Posts
    2

    Angry Table fetching remote server

    Hi friends,
    I have oracle ODBC Dirver which easily connect and fetch data to a new excel sheet according to the query.



    But I wana fetch data to a access table from a remote server database which will automatically update the data, through the query saved.

    excel is workin good with automatic update option but can't fetch data to access table.

    please help.
    thanks in advance.

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Do you want to link to the external tables and then work on them with

    Access queries or are you trying to somehow directly get the data with a query?

  3. #3
    Manotosh is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2011
    Posts
    2

    reply

    actually our server has 13 nos of office data I just need only my office data, for this i've to execute a query matching my office data, then the cohsen data to be imported to a table and it should be autometically updated. And another thing is there is a problem to connect with access to the ODBC, although it working good with msquiry and put the data in a excel sheet but now its data volume are out of capable for excel.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Truncating SQL Server table from Access
    By lbrady in forum Import/Export Data
    Replies: 3
    Last Post: 03-01-2013, 04:46 AM
  2. Replies: 4
    Last Post: 09-06-2011, 08:03 PM
  3. Linked SQL Server Table Problems
    By jalton in forum Import/Export Data
    Replies: 3
    Last Post: 02-13-2010, 12:52 AM
  4. Linked Table To SQL Server?
    By snkscore in forum Import/Export Data
    Replies: 3
    Last Post: 12-09-2009, 06:36 AM
  5. Getting date/time from remote server
    By mxfrail in forum Programming
    Replies: 4
    Last Post: 09-21-2009, 07:26 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums