+ Reply to Thread
Results 1 to 1 of 1

Copy Excel to Text file and pass Text file to Access Table

  1. #1
    Registered User
    Join Date
    07-27-2011
    Location
    Spain
    MS-Off Ver
    Excel 2003
    Posts
    1

    Copy Excel to Text file and pass Text file to Access Table

    Hi ! Greetins from Spain:

    For my work need a vba macro to pass a excel sheet to a access table. Macro pass the excel to a .txt file and then, i pass the txt to a access table.

    Well, monthly i have to work with a excel sheet like that called sheet1 in my example workbook.
    I need to pass using a macro the excel worksheet to a txt file like that example.txt attached in my example file .

    It would also work if using a vba macro, i could convert the sheet1 in a worksheet like the example worksheet in my workbook.

    Itīs difficult so thatīs the reason why I had post my problem

    Regards
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1