WOrk with large dataset

[Judith_Chao]

Hi everybody

At my office I must work with Excel older version, 2013 and 32 bits :S (IT guys only provide us this SW). At this proyect, I must work with a large dataset and access all days to check data and actualize it each week with the new unique ID new Clients. Also, I must store in it the state of the transaction and the total number of it. At this scenario I have:
1. A large "database" of names stored at one Excel File (now we have 100.000 rows but it grows every day) with unique Id of clients of the web (excel Client list)
2. We must know the "status" of this person (if we have already finished his web orders etc).
3. I try to figure out which is the better way to access data (make queries etc) as fast as possible, but I don't find information about which is the better model to use:
1. - Convert Client list to another format: TXT, XML but for access it later I see I need to convert it ...
2.- Make relative formulas from The excel for day use to the data
3. - Convert the data at binary (I don't Know if really in this format I can write the client list excel ...)
4.- Using data model, but I really don't know if that reduces time to access.

I hope you can give me some ideas to fix this problem because we need to define it as fast and optimize as we can. Thanks in advance

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Marc L]

Hi !

As you can work with a large dataset since 2007 version but Excel is not the way to go, better is to use Access for example …