Search results

Thanks BukHix! I think the problem is due to the exporting process into .csv files. The date formats in all the tables in the Access database were initially set up as "dd/mm/yyyy", but the exported files don't keep that format and instead the dates are kept "dd/mm/yy 00:00:00" Thanks anyway...

Hello again! To make clearer my question: All the original date formats in the Access database to be exported have the following imput mask: "dd/mm/yyyy" Does anyone know why the conversion into csv files, sets up the dates as "dd/mm/yy 00:00:00" I hope this helps to get any ideas...

Hello! When I run the following code: Private Sub CmdExportFiles_Click() Dim dbs As Database, tb As TableDef Set dbs = CurrentDb For Each tb In dbs.TableDefs If Left(tb.Name, 4) <> "MSys" Then DoCmd.TransferText acExportDelim, , _ tb.Name, "S:\shared\sad\tests\" & tb.Name &...

Fornatian, Thanks very much!! I just tested and it works! Silvia

Hello! When I run the module to export all the tables in an Access database and convert them into csv files, all seems to work but the problem is that the system tables or system objects are exported as well. Can I export only the tables I really want ignoring these "hidden tables" (they contain...