Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003

    Unanswered: database splitter

    Im in access 2000 sp3.

    I imported and excell file that i want to break into database tables,

    I tried : &Tools &Analyze Table

    i select next 3 times (going through the wizard using the defaults)
    and on the 4th next my access program completely disappears!

    Hmmm whats goin on here?????

  2. #2
    Join Date
    Oct 2003
    Provided Answers: 1
    What is the problem now? Could you import the Excel file?
    You want to split the imported table (say 2000 records) into small tables say 5 tables each wiht 400 records. Is that true?

  3. #3
    Join Date
    Oct 2003
    2000 recs comming in 100 colums, I was trying to get the analyzer to split the xl file into 5 tables 20 cols 2000 recs each.

    I moved the file to my laptop with 2002 access and it worked,,

    The wizard didnt even come close to what would have been a good design so i did it myself

Posting Permissions

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