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

    i have a program i wrote in excel but it is too slow - would it work faster in access


    my excel program has 45 columns, 3,000 rows and 6,000 kb.
    it is unbearably slow.
    I am going to try linking it to an access program and see how it works.
    is there a better solution?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    That is not a lot of data for Access to examine if you *import* the spreadsheet. It really depends on what you are attempting to do.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,511
    I would say yes, put it in access.

  4. #4
    hapm is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2014
    Posts
    197
    3000 rows and 45 columns aren't that much for excel as well. What kind of formulars are you working with? If you are solving a relational related problem, it is worth trying access. To give you a more specific answer it would be helpful to know what your application does.

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

Similar Threads

  1. Replies: 12
    Last Post: 10-03-2013, 12:32 PM
  2. Replies: 3
    Last Post: 08-04-2013, 10:53 AM
  3. Replies: 1
    Last Post: 05-10-2011, 08:31 PM
  4. Invoice Program Will Not Work in Windows 7
    By wallyb in forum Access
    Replies: 1
    Last Post: 08-02-2010, 02:00 AM
  5. Import Excel into access does not work
    By hawg1 in forum Import/Export Data
    Replies: 1
    Last Post: 05-28-2010, 12:05 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