If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel on XP PRo, or SQL on Server 2003?
I need to migrate an Excel app I developed ten years ago, that has evolved into something with a life of it's own. But I know little to nothing about database platforms and development. The Excel file stores info in 60 cells on each line of the spreadsheet, a new line for every sample that is received. This spreadsheet grows to 10,000 lines in a couple months and I have to archive and purge it back down to a more stable size. The biggest plus I want is for more than one user to be able to enter data in the file at once. Although it is unlikely more than 10 users will access the file at once, I didn't think it would grow to THIS size.. SHOULD I focus on having this migration move into an ACCESS format, running on WinXP Pro? I have a partnership action pack from Microsoft, and I'm trying to figure out what the best set up would be. I'm probably going to hire a consulting firm to handle this migration, so I'm sure they'll tell me what they recommend. BUT in the meantime... I'd like to load OS and software that will work best with where I'm eventually going.... What came from Microsoft... Office Pro '03 (10 user) Windows Server 2003 (10 user) Windows Small Bus. Server 2003 (10 user) Windows XP Pro (10 user) Windows XP Pro x64 (10 users) SQL Server 2005 (10 users) Roll out the Server 2003, or stick with XP Pro? |
#2
|
|||
|
|||
Excel on XP PRo, or SQL on Server 2003?
60 columns and 10,000 rows/quarter, sounds like a place to start would be
data normalization. Since you want to have multiple users, and you will be using some sort of 'expert' help. I would recommend going to the SQL server 2005 solution with n-tier application structure (Sql 2005 -- WebService --SmartClient) I will be interesting to see what others have to say. Ed Warren. "analyst" wrote in message ... I need to migrate an Excel app I developed ten years ago, that has evolved into something with a life of it's own. But I know little to nothing about database platforms and development. The Excel file stores info in 60 cells on each line of the spreadsheet, a new line for every sample that is received. This spreadsheet grows to 10,000 lines in a couple months and I have to archive and purge it back down to a more stable size. The biggest plus I want is for more than one user to be able to enter data in the file at once. Although it is unlikely more than 10 users will access the file at once, I didn't think it would grow to THIS size.. SHOULD I focus on having this migration move into an ACCESS format, running on WinXP Pro? I have a partnership action pack from Microsoft, and I'm trying to figure out what the best set up would be. I'm probably going to hire a consulting firm to handle this migration, so I'm sure they'll tell me what they recommend. BUT in the meantime... I'd like to load OS and software that will work best with where I'm eventually going.... What came from Microsoft... Office Pro '03 (10 user) Windows Server 2003 (10 user) Windows Small Bus. Server 2003 (10 user) Windows XP Pro (10 user) Windows XP Pro x64 (10 users) SQL Server 2005 (10 users) Roll out the Server 2003, or stick with XP Pro? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2003 & SQL Server 2005 | Neil | General Discussion | 4 | January 30th, 2006 04:46 AM |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
Outlook 2003 does not recieve emails | Mark Marek | Installation & Setup | 13 | October 18th, 2005 04:51 AM |
Useless Access 2003 | tired, angry, sucidial and bored | General Discussion | 10 | July 21st, 2004 11:52 PM |
Excel Add-in for SQL Server Analysis Services | Uyesato | General Discussions | 1 | June 24th, 2004 05:01 PM |