Export MSAccess table to CSV

Question

Export MSAccess table to CSV

Luca Tramontana 81

Dear all,

from an MSAccess Database table I need to extract the content to a csv file.

As this csv file needs to be imported in a SQLite table and especially for the Date field the format must be YYYY-MM-DD HH:MM:SS (like 2025-11-27 00:00:00 NOT 2025-11-27 0:00:00); I need to know the correct setting to do it.

I have tried to set the csv export as below:

User's image

but the final date value field will be like this: YYYY-MM-DD H:MM:SS

User's image

Any idea?

Thanks

0 comments

Answer accepted by question author and recommended by moderator

0 additional answers

Your answer

Answer 1

Try creating a query in MS Access that formats the date fields correctly for SQLite. For example, if your table is ACTIVATED_TABLE_2021_01 and the date fields are Expiration_Date and Activated_Date, you can use:

SELECT 
    Warranty_Code,
    Warranty_PN,
    Warranty_Descr,
    Serialnumber_Or,
    Product_Purchase,
    Brand_Of_FG,
    AGS_SO_Number,
    Format([Expiration_Date], "yyyy-mm-dd hh:nn:ss") AS Expiration_Date,
    Format([Activated_Date], "yyyy-mm-dd hh:nn:ss") AS Activated_Date
FROM 
    ACTIVATED_TABLE_2021_01;

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin