3 ms·
It really isn't. Access is great for _persistent_ data, but if I have a .csv file and I just need it quickly sorted so I can grab the top 100 entries after mult
by TheRealPomax 6y ago
It really isn't. Access is great for _persistent_ data, but if I have a .csv file and I just need it quickly sorted so I can grab the top 100 entries after multi-column sorting, Access is about as useful as SQL: pointless for what I need.
- unnouinceput 6y agoThen you definitely don't know to use it to it's usefulness. But that's OK, as long as Excel fits you needs. You do know, just like in Excel, you can simply right click on column data and select order, yes? Or filter if you want. To your point, if I have a .csv file I can simply copy/paste it to Access in a new table, and just next/next through the wizard that will pop-up. Now do a test, get that .csv file, with 20k rows, and paste it in Excel 50 times, so you'll have 1M records in a table. Let me know in how much time Excel vs. Access will order it.
- tracker1 6y agoThat's my quick and dirty shortcut to get one-off csv imported into a database (even remote rdbms)... Usually paste into a new database table, then query/insert and drop said table when done. That or I'll write a one-off node script.