OT - SQL to ACCESS HELP

[joe buckle]

I need to run some queries on a few tables out of a SQL database.

I've got it all setup in a Access DB to massage the data and extract all i need, ect. Problem is SQL uses the int(11) format for dates and the Access doesn't convert it. I can't find my F'n SQL books and find the proper syntax to convert the table before i run the query.

anybody got a quick down and dirty way to convert the date? Already tried Excel and didn't find what i need.

Thanks for any help or resources. give me a nugget and i'll crawl back under my rock and finish this crap

[Cloudbuster]

I linked a SQL DB table into Access, then did a Insert Into using date/time data records from the linked SQL table into an Access table, and had no trouble.

Maybe, you can create a view in SQL on the table with this kind of thing on the date field

SELECT CONVERT ( varchar(8) , {datefield}, 112 ) + ' ' +
CONVERT ( varchar(8) , {datefield}, 108 )
from

It generates a 'YYYYMMDD HH:MM:SS' formatted string

Feel free to PM me if you want

(Oops, I always assume MS-SQL)

__________________
Maynard

08-31-2006, 08:00 AM

[joe buckle]

the SQL is in mySQL. i usually like to download it to my server and work with it in Access. it's not a really large DB, so, Access or Excel can chew on it easily.