|
|
Converting a Spreadsheet to a Database
Do you have an unwieldy Microsoft Excel spreadsheet that you'd like to convert to an Access database? This illustrated tutorial walks you through the process, step-by-step |
| http://www.databases.about.com/library/weekly/aa123100a.htm |
 |
 |
Hits:132 |
Access 2000 How To's: Calculating Working Days
This Access 2000 How To's article explains how to use Access 2000 date functions when determining 1) the number of work days representing an interval between two dates, and 2) the projected end working date calculated from a start date and number of hour.. |
| http://www.databasejournal.com/features/msaccess/article.php/1552691 |
|
|
Hits:109 |
Grab Access data online
Even novice developers can quickly learn to make their Access databases available on the Web |
| http://builder.cnet.com/webbuilding/0-7537-8-6939280-1.html?tag=st.bl.3880.pro_h |
|
|
Hits:105 |
|
|
Code Sample: Excel to Access Converter
Use this simple VBScript to convert .csv Excel files to .mdb Access files |
| http://15seconds.com/howto/pg000950.htm |
|
|
Hits:98 |
Use Jet's ShowPlan to write efficient queries
In large databases, an inefficient query can reduce performance to a crawl. The ShowPlan feature of the Access Jet engine lets you plan more efficient queries, optimize your database, and boost performance |
| http://builder.com.com/5100-6388_14-5064388.html?tag=ft |
|
|
Hits:94 |
Views & Procedures in Access
The Query object in Microsoft Access acts as both, a View and a Stored Procedure. This article demonstrates how to access the Query object as a view or as a stored procedure through your ASP.NET pages |
| http://aspalliance.com/hrmalik/articles/2003/200303/20030301.aspx |
|
|
Hits:91 |
Protecting your Access Database .mdb File
When creating Web applications with an Access database, developers often save the Access database to a Web accessible folder. That is, they may save the actual .mdb file as: C:\INetPub\wwwroot\MyDB.mdb. The downside to this approach is that anyone who kn.. |
| http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=166 |
|
|
Hits:90 |
|
|
Renaming Access Database Tables
Have you heard of ADOX INSERT INTO `sites` VALUES (ADO Extensions)? This technology is an object extension to ADO INSERT INTO `sites` VALUES (classic ADO, not ADO.NET) that provides developers with an object model to represent database schema information. That is, you can use an object model to find out wha.. |
| http://4guysfromrolla.com/ |
|
|
Hits:87 |
Page: 1 |
Home
