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
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]
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
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
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]
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
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
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
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