User Profile

Collapse

Profile Sidebar

Collapse
edralyn
edralyn
Last Activity: Mar 1 '07, 08:37 AM
Joined: Feb 28 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • edralyn
    started a topic Transfer Spreadsheet method in visual basic
    in Access

    Transfer Spreadsheet method in visual basic

    hello everyone! i have a problem in coding for my system...i want to know how could i use the
    Code:
    Const transferDir = "c:\my documents\"
rangeName = "Companies"
tableName = "Companies"
DoCmd.RunSQL "delete from " & tableName
DoCmd.TransferSpreadsheet acImport, 8, tableName, _
transferDir & "OriginalData.xls", True, rangeName
    i want this code to be transferred.....
    See more | Go to post
    Last edited by willakawill; Mar 4 '07, 05:18 PM. Reason: code tags have square [] brackets
    • edralyn
      started a topic MS Access to VB
      in Access

      MS Access to VB

      guys i just want to ask about
      Code:
       DoCmd.TransferText acImportDelim
      how cud i use this code
      See more | Go to post
      Last edited by edralyn; Feb 28 '07, 06:19 AM. Reason: wrong grammar
      • edralyn
        replied to Import Excel to Access
        in Access
        where will i write this code...sorry to ask.....
        See more | Go to post

          Leave a comment:

        • edralyn
          started a topic export problem in excel to access
          in Access

          export problem in excel to access

          guys can u please help me...what is the code for exporting an excel to access
          See more | Go to post
          • edralyn
            started a topic Import Excel to Access
            in Access

            Import Excel to Access

            can i ask something? i had a problem in my system i'm just a beginner in making a system...my problem was how cud i connect i export an excel data to my system...please reply...i badly need it
            See more | Go to post
            No activity results to display
            Show More
            Working...