Timeline for Is there a database tool that bashes data with HUGE excel files?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 6, 2015 at 15:24 | answer | added | Vérace | timeline score: 2 | |
| Aug 6, 2015 at 12:46 | history | edited | user1551672 | CC BY-SA 3.0 |
added 165 characters in body
|
| Aug 6, 2015 at 12:40 | comment | added | user1551672 | Not sure if they even know what an SQL server is honestly. What do you think our database was? Its not a fancy kind of database and its not even centralized. Like we need to get various files from different tools. One is a text file that is 2gb in size where all mobile numbers and their balance our put in there since 2012. We match the excel file with this text file via Access. which is a tedious process. | |
| Aug 6, 2015 at 12:37 | comment | added | Kin Shah | How about importing excel files into SQL server using SSIS. This can be automated, but you would need SQL server. If your database size is less than 10GB, you can use SQL express edition. | |
| Aug 6, 2015 at 12:34 | review | First posts | |||
| Aug 6, 2015 at 12:42 | |||||
| Aug 6, 2015 at 12:33 | history | asked | user1551672 | CC BY-SA 3.0 |