Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    8

    Unanswered: Table structure for Import Excel File

    I am having a little issue setting up a table to take an excel file i have which represents time per distances into an access table. I have set a compound key as date and time, and a foreign key to Horsename as this has its own table. Whether I create my own table and import or let Access import to a new table and use the table wizard I am not getting a good result.

    These are the files i am using
    the excel file 2shared - download 1stDraft.xlsx
    The Access file 2shared - download Comment.accdb
    In the last column of the excel file you will see a column called total time in the format 01:10.00 this represents 1 minute 10 seconds and 00 hundredths.

    I cannot seem to get a table format to host the table which represents a portion of my planned db. The below screens outline my files.

    The excel File http://i988.photobucket.com/albums/a...xcelImport.png

    Access http://i988.photobucket.com/albums/a.../AccessRel.png and http://i988.photobucket.com/albums/a...w/TblEvent.png

    Any help appreciated

  2. #2
    Join Date
    Aug 2009
    Posts
    8
    Unfortuneately the project I knew this was a hard question if you know anyone that would have an idea baout this please let me know.

    Thanks

    Sayth

Tags for this Thread

Posting Permissions

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