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

    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
    Location
    Ger
    Posts
    1,969
    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
    Posts
    311
    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
  •