Results 1 to 2 of 2
  1. #1
    rgrstvr is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    25

    Converting excel files to access files for an online nursery plant pricelist

    I have some 2010 excel files with thousands of rows of information that I have used for years to produce our nursery online pricelist. Now we are re-organizing our nursery and pricelist and I want to convert to access files. But I have several questions.



    (1) When I convert each file to access it seems impossible to get rid of the root excel files. I guess that could be a blessing because it would be easy to modify through the root excel files. But I wonder if in the long run it might some way be a problem.

    (2) I would like the primary key fields to be the plants names rather than numerical code and I wonder if that will work ok.

    I tried to attach sample excel files to this note but my 2010 excel files were not accepted.

  2. #2
    dsmacs is offline Advanced Beginner
    Windows XP Access 2010 (version 14.0)
    Join Date
    Oct 2009
    Location
    Perth Western Australia
    Posts
    52
    1. You may have linked the excel file, not imported it? It will be a problem if you change the structure of the table in access so not all field are the same, ie to reduce redundant data eg suppliers, you may need a differnt table/s layout.

    2. Using a autonumber for the primary key is more efficient.

    You need to zip the file to load it.

    Regards
    Darren

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

Similar Threads

  1. Replies: 9
    Last Post: 10-31-2013, 06:51 AM
  2. Replies: 3
    Last Post: 10-01-2010, 07:04 PM
  3. How to get data out of Access MDE files?
    By access22 in forum Import/Export Data
    Replies: 3
    Last Post: 04-29-2010, 02:38 AM
  4. Cannot import excel or text files
    By donald_s in forum Access
    Replies: 2
    Last Post: 04-13-2010, 11:48 PM
  5. Export Query to Various Excel Files
    By dalet in forum Import/Export Data
    Replies: 7
    Last Post: 11-09-2009, 09:22 AM

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