Excel, Excel 2007, MS Office, Programming, Software

Skydrive Excel: Find Duplicates Between Two Columns

Find Duplicates in Excel
Find Duplicates in Excel

There are some great ways to hunt down duplicate values in the desktop version of MS Excel. Today I will take a look at using the free online SkyDrive version of Excel that is integrated with Outlook.com to find duplicates between two columns. Continue reading “Skydrive Excel: Find Duplicates Between Two Columns”

.Net, ADO.NET, ASP.NET, C#, DB Connection Example, Example Connection, Excel, Excel 2003, Excel 2007, JavaScript, JQuery, Programming, Regular Expressions, Web Development

JQuery with ASP.NET: Save Copy / Paste Excel Data to a Database Table

Have you ever wanted to help your users move data from Excel to your Web application? In this article I will give an example in ASP.NET that takes copied Excel spreadsheet rows from the user’s clipboard and saves the information to a SQL Server database table.

Since ASP.NET runs at the server level, you will need to use JavaScript/JQuery to get the Excel information from the user’s clipboard. You will need to use a different command to get the information depending on the user’s browser. In this example, I code specifically for Internet Explorer, but this is just since I am giving an example. In a real-world application you would code for all of the major browsers. Continue reading “JQuery with ASP.NET: Save Copy / Paste Excel Data to a Database Table”

Access, MS Office, Programming

Using a Batch File to Start an Access Application Hosted on a Local Area Network

Microsoft Access
Microsoft Access

If you are creating MS Access applications, then you will probably want to set up custom workgroups and give your users the ability to log into your application as a workgroup user that has various levels of access. You will also want to host the Access application centrally on your LAN to avoid problems with multiple instances of the database existing.

The easiest way set up your application is by creating a custom .MDW (workgroup security) file and hosting this together with your main .MDB database file on your local area network for your users to access. Then in order for your users to be able to launch the application and log in from their desktop machines, you can create a simple batch file for them to click on.

For example, if you had your Access files on a network path such as:

\\MyNetwork\AccessApps\

Let’s assume your users are running MS Access 2002 on a Windows XP machine. This means that on their local machines, the default path to the MS Access executable would be:

C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE

This path above will of course vary based on the version of MS Access and the version of Windows that your users are running.

Continue reading “Using a Batch File to Start an Access Application Hosted on a Local Area Network”