Monthly Archive: December 2009

0

Disable Digital Driver Signing in Windows 7

When you try to install some device drivers on Windows 7, you might come across a warning message that those drivers should be digitally signed. You can get disable this driver signing warning message...






0

Digital Photography Printing Workflow

If you have not already installed the profile(s) on your system, you need to do so before proceeding. Open the image in Photoshop. Note: If you are presented with a profile mismatch dialog, select...






0

Open a Delimited Text file using OPENROWSET and OPENDATASOURCE

SELECT * FROM OPENROWSET (‘MSDASQL’, ‘Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\Users\Kevin\Downloads\zcugoem;Extended properties=”ColNameHeader=True;Format=Delimited;”’, ‘SELECT * FROM ZCUGOEM.TXT’); or SELECT     * FROM   OPENDATASOURCE(‘Microsoft.Jet.OLEDB.4.0’, ‘Data Source=E:\SQL\;Extended Properties=”Text;HDR=No;FMT=Delimited”‘)…[ZCUGOEM#TXT]