Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-25 : 08:28:31
|
| biju rama writes "Hi there:I am in the look out of a way of converting my Excel Spreadsheet in to a database. This excel spreadsheet is a shared one, and used by multiple users using Tools->ShareWorkbook option. It was working fine for couple of weeks and now whenever anybody tires to save it keeps locking and the has to use SaveAs and then delete the oldfile, and rename it.I was wondering if somebody can let me know of a way of converting this in to a database using Access 2000/MS-SQL 2000. Will this solve my problem.. Also can somebody explain me, the meaning of Recod level locking that these softwares provide..Thanks for your answer in advance...Biju" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-03-25 : 11:17:03
|
| You might be better off hiring a contractor for a day to look at what you want to do - and probably do it for you and explain the process in that time.If you have been coping with a spreadsheet then access will probably do what you need - although this does have it's own problems.You should also investigate normalising the data to save the trouble later and it will show up any anomolies in the data.Also you should look at putting constraints (to maintain integrityand indexes (for efficiency) on the database.These things are a lot easier the earlier they are done and will probably teach you a lot about the business rules that you may be applying without realising it.Record locking means that only the record being updated is locked and all others are still accessible by other users. Whether it actually works like this (or is desirable) depends on how the database is implemented.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy.Edited by - nr on 03/25/2002 11:18:52 |
 |
|
|
melisa_uy
Starting Member
2 Posts |
Posted - 2002-04-02 : 01:57:36
|
if you just want to convert a spreadsheet to an ms access database, here are the steps. Got it from the help file :)Convert a Microsoft Excel list to a Microsoft Access databaseTo convert an Excel list, you must have Access installed. If the Convert to MS Access command does not appear on the Data menu in Excel, you need to install and load the AccessLinks add-in program. - Select a cell in the Excel list.
- On the Data menu, click Convert to MS Access.
- To create a new Access database for the list, click New database. To add the list to an existing Access database, click Existing database, and then type the path to the database in the box under Existing database. To look for the database on your system or network, click Browse.
- Click OK.
The Access Import Spreadsheet Wizard and Table Analyzer Wizard guide you as you permanently convert your Excel list to an Access database.
NotesAfter the conversion, AccessLinks places a text box to the right of the original list stating that the list has been converted to Access data. The original data, however, does not change.For more information about the Access Import Spreadsheet Wizard and Table Analyzer Wizard, see Access Help. **IMPORTANT**After you convert a list to Microsoft Access, you maintain the data only in Access. Changes you make to the Access database after the conversion do not affect the Microsoft Excel list. |
|
|
|
|
|
|
|
|
Accessing database by multiple users