Install Microsoft.Jet

Hi all, I have tried to import the excel to db , but i get the following error, The OLE DB provider Microsoft.Jet.OLEDB.4.0 has not been registered. how can i install the Microsoft.Jet? System Info: OS Name Microsoft(R) Windows(R) Server 2003, Enterprise Edition for 64-Bit Itanium-based

how to Get file modified time and date of file by using builtin function or procedure in sql?

Hi All, how to Get file modified time and date of file by using builtin function or procedure in sql? Thanks, Siva -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to Get file modified time and date of file by using builtin function or procedure in sql?

Ananda Kumar wrote: which file are u talking about. regards anandkl Ordinary temp file.. say example in C:\output.txt Actually i have given that file as input to some procedure, based on that modification time we have calculate some details. -- MySQL General Mailing List For list

Re: how to Get file modified time and date of file by using builtin function or procedure in sql?

Ananda Kumar wrote: you can do that using OS command, any specific reason u want to use stored proc to get this information. OS Command? could you explain with examples? because, I have more # of input files.. thats why iam going to procedure.. -- MySQL General Mailing List For list

How do I get the file names from a certain directory in SQL?

Hi all, How do I get the file names from a certain directory in SQL? Thanks, Siva -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How do I get the file names from a certain directory in SQL?

Martijn Tonies wrote: Hey, How do I get the file names from a certain directory in SQL? It seems to me that you're trying to do things that are beyong SQL really. SQL is about the database, not about a file system. Yes, by creating a DBMS that allows you to write functions that

Re: WHERE .... IN

How about: WHERE ( field1 LIKE '123,%' OR field1 LIKE '*,123,%' OR field1 LIKE '%,123' OR field1 = '123' ) Note that this could that a long time on large tables. You'd be better off to normalize your tables ;) How can we normalize the tables? could you explain bit more? Thanks, Siva

Query for details

Hi all, I have one table as following AccessDetails DateTimeUserName SiteName StatusVirus_Category |2008-04-23 | 14:27:38 | 172.16.1.40| en.wikipedia.org | A | unclassified | | 2008-04-23

Query problem

Hi all, Iam having the one table name called AccessDetails and data inside that tables is following, DateTime UserName SiteName ScanType Status Virus_Category | 2008-04-16 | 13:05:31 | 172.16.1.22 | - | www.veer.com |C | A