Recent content by Barry

  1. B

    Import data from Excel(2007) spreadsheet into Access(2007) form using VBA

    Thanks for your response. I was a little confused by the Access jargon but I got the gist of what you were trying to tell me. In the end I created two tables in Access and made one a subdatasheet of the other. Then I divided my data in Excel into 2 Excel spreadsheets, maintaining the...
  2. B

    Import data from Excel(2007) spreadsheet into Access(2007) form using VBA

    For many years I used Excel as a database and having recently graduated to Access, have much information that I now want to transfer from Excel to Access. My problem is that in one case the data from each spreadsheet row needs to be split into 2 Access tables, one a subdatasheet of the other. It...
    • Barry
    • Thread
    • Replies: 2
    • Forum: Forms
  3. B

    Hi

    I am a pensioner. I live in South Africa. I am relatively new to Access having used Excel for my database needs up till now.:confused:
See more
Top Bottom