Results 1 to 10 of 15

Thread: Excel to Excel Data transfer without opening any of the files(source or target)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-23-2012, 11:55 PM #8
    Rajan_Verma
    Rajan_Verma is offline
    Member Rajan_Verma's Avatar
    Join Date
    Sep 2011
    Posts
    83
    Rep Power
    15
    Hi Rick
    you can change the Provider .
    Replace "Provider=Microsoft.ACE.OLEDB.12.0" with "Provider =Microsoft.Jet.OLEDB.4.0"

    Rajan.
    Last edited by Rajan_Verma; 03-23-2012 at 11:56 PM. Reason: spellingMistake
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Excel 2013: How To Check How Many Excel Files Are Open
    By peccora3 in forum Excel Help
    Replies: 4
    Last Post: 06-09-2013, 01:43 AM
  2. Macro to copy data from a set of excel files
    By Sreejesh Menon in forum Excel Help
    Replies: 5
    Last Post: 11-15-2012, 11:17 AM
  3. Macro for Opening files and copy the contents of the File
    By ravichandavar in forum Excel Help
    Replies: 16
    Last Post: 08-15-2012, 09:17 PM
  4. Protect Excel File From Opening Only In Designated Computers
    By mikeydo in forum Excel Help
    Replies: 1
    Last Post: 06-26-2012, 08:17 PM
  5. Collate Data from csv files to excel sheet
    By dhiraj.ch185 in forum Excel Help
    Replies: 16
    Last Post: 03-06-2012, 07:37 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules