Posts Tagged ‘Data’

Import Data from a local Excel file using MSSQL code?

Question by : Import Data from a local Excel file using MSSQL code? I have 2 excel files one with 2 rows and 7 columns and another one with 28 rows and 32columns.I am new to MSSQL and this is the code i got after searching around the internet. SELECT * FROM OPENROWSET(‘Microsoft.Jet.OLEDB.4.0′, ‘Excel 8.0;Database=Y:\TestBooks.xls’, [...]

How to find tables in SQL databse which all are contain data and also which are empty table?

Question by dev .: How to find tables in SQL databse which all are contain data and also which are empty table? In my database(SQL server 2000) , it contains 125 tables, i need to find which tables empty and which are contain data??? any query is there? Best answer: Answer by Alfonso EHere’s a [...]

Have you backed up your data today?

It’s World Backup Day. What better way to celebrate and stress the importance of backing up than by telling Crave your data loss horror stories? Tsk, tsk. Very few people back up their data daily, let alone monthly. (Click image to view full infographic.) (Credit: World Backup Day) Today is World Backup Day, and though [...]

Collecting Radon data in the name of science and safety

posted Mar 27th 2012 8:01am by Mike Nathan filed under: arduino hacks, home hacks, news When [Chris Nafis] built an addition onto his historical home he found that a Radon problem, previously mitigated with plenty of concrete, seemed to rear its ugly head yet again. He eventually resigned himself to installing a Radon fan and [...]

How many people hate Windows Vista “Data Execution Prevention”?

Question by weirdalyankovick: How many people hate Windows Vista “Data Execution Prevention”? I mean really just the name sounds like it will stop you from using anything non-micro$ oft but its point is stupid to stop any program that (In people terms):any program that request a sudden need for a high amount of resources to [...]

How to check Oracle data pump export dump integrity?

Question by : How to check Oracle data pump export dump integrity? Given a dump file made from Oracle expdp, is there a way to check its integrity without importing the dump to a temp schema? By integrity, I mean, it’s sure that when I import that dump again in the future, its contents would [...]

Please Help Urgent: Data Base Error?

Question by νανσσм™: Please Help Urgent: Data Base Error? I am consistently getting this message: “Database Error: Unable to connect to the database:Could not connect to MySQL” when I try and access certain websites. Otherwise, sites like facebook are working fine and just as fast. Someone PLEASE help me. If you could explain the fix [...]

Q&A: how can I convert Dbase III files into something usable, like excel? I have data files & executable pgm only.?

Question by lisahasen: how can I convert Dbase III files into something usable, like excel? I have data files & executable pgm only.? Best answer: Answer by unngaYou can use Access to import Dbase III data and from Access, export it as an Excel file. Know better? Leave your own answer in the comments!