Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: Need to import records from Excel

    So, this is pretty Access 101, I know, but if anyone can offer advice/examples of importing data from another source, I'd really appreciate it. I'm just looking for some code to clone/change to do lots of the looping and error checking for me. Here's the situation. We have some spreadsheets that, naturally, are not de-normalized. I'd like to take the data from the spreadsheet and create records in Access in normalized table structures. If anyone has any code I could use as a starting point, that would be great. Particularly if it has any kind of small parameter entry form that asks the user where the source data is, which columns should be imported, etc. I know it's a lot to ask for, but I"ll take what I can get.

  2. #2
    Join Date
    Jan 2003
    do you want it done automatically (just click a button or something) or do it manually? if manually, pls use built-in access import data tools. if auto, need some vb codes but largely depends on excel strustures

    hope this helps

Posting Permissions

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