I am collecting information from a database into a .csv file. I also want to query this .csv file and based on a timestamp field in the .csv flie, select only certain rows. The front-end that I am using is VB 6.0.

I am facing the following problems -
1) I am not able to directly query the file using the timestamp field
2) I tried to import the .csv file into an MS-ACCESS database - there is a mismatch in the timestamp datatype.

Can anyone help ASAP? The result is very time critical.

Thanks in advance,
aspiring_db_fundu

why not query the database before you export the csv-file?

Harold

Try to link the CSV file into Access, create a query that formats your data properly and call that query via ADO.

Should work fine.



Sal

I have tried exporting to the access file, but in the timestamp field the seconds part is missing, also I am not able to query properly, because while exporting it take the column as string not timestamp. If I manually change the column to Timestamp also it is not working.

Can anyone help please!

It is not how much we do,
but how much love we put in the doing.

-Mother Theresa

Are you sure that the "seconds" is really missing or is the field just formatted so you don't see it? I've put things into databases where the field is date/time, and incldued the seconds, and not lost the seconds.

If you have MSquery installed, it will write a query for you closer to that accepted by ADO than will Access, but both will work after editing.

Dave