Import from .CSV or .TXT

[accesscoding]

Hello,



I am working on a project which for some task has to deal with a legacy application accepting input only in the form of .MAT (Microsoft Access Table) files. I haven't worked with MS Access in the past.

The code that I have written provides output in the form of a .CSV or .TXT (tab-delimited file) and this becomes input to the legacy application which needs input in the form of a .MAT file only. Is there a way to convert .CSV/.TXT file in .MAT format? In the longer run, I will have to perform this step for a few thousand iterations, so any pointers to sample scripts or documentation that could simplify this case (a simple .CSV/.TXT to .MAT conversion) would be of great help.

Thank you for reading this post.

[ajetrumpet]

what does this have to do with Access? It looks like it doesn't, at all.

As for the extension change, have you tried manually changing the extension of one file first, to see if it works fine like that? and if it does, you can use VBA's NAME function to rename files through the file system as many times as you want with a loop.

but again, where does Access fit in?

[Rawb]

My understanding of MAT files (which is pretty limited) is that you can't do what you're asking.

A MAT file is nothing more than a Shortcut (like a Desktop Shortcut) pointing to a Table inside an MDB file. It doesn't contain of the Table's data.

In fact, you can open MAT files in Notepad and get readable info!

[orange]

See http://www.fileinfo.com/extension/mat for info

[thhui]

If MAT is just an access table shortcut,
then what the output really required is in fact the access data table.

You just import the csv or txt into the access table and then create the MAT shortcut in MS Access 2010 by clicking and dragging it to desktop.