Results 1 to 2 of 2
  1. #1
    robinCris is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2017
    Posts
    3

    import from excel

    Hello there



    I didn't use access for long time and got some easy questions.

    I created a database with 3 tables.
    Every day I need to press a button on a form or something else and select 2 excel spreadsheets.
    One excel is for sent table and one for receive table.
    Every excel got only one sheet.
    The 3rd table I want to use to keep track that no sheet is loaded twice or there are some dates missing

    I thought the best parctis is:
    1. to load the excels into temp table
    2. To check that every row in every sheets beloog only for one day.
    3. if yes. go to check if the excel from that day have been loaded
    4. if yes. reject and prompt.
    5. if not, import it to the right table table by insert sql.

    Do you think this is the right way?
    Where can I find an example for something I can modifay.

    Please advice
    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    sounds fine to me.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-28-2017, 01:34 AM
  2. Replies: 10
    Last Post: 06-16-2014, 08:37 AM
  3. Import access query data into excel file, using excel vba
    By exceljockey in forum Import/Export Data
    Replies: 3
    Last Post: 11-15-2013, 02:36 PM
  4. Replies: 4
    Last Post: 12-17-2012, 01:21 PM
  5. VBA to open excel, import on close of excel
    By bdaniel in forum Programming
    Replies: 0
    Last Post: 03-20-2010, 02:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums