Importing from Data Acquisition System ???

[Korski]

Our company has just purchased a data logging system that reads industrial
sensors and records many data points per second. It then dumps this
information into separate files due to the extremely large size and amount of
data being recorded. It can do this by month.....as any bigger and the file
gets too large.

What is the best way to import data into a single table or multiple tables
automatically from multiple "monthly files" ? ....we're talking hundreds of
thousands of data points (records) per file? I'm not sure how to set up
something like this with new file names every new month.

The file type is an .MDX file that is dumped from the data logger. Perhaps
someone is familar with a similar system.

Any help is greatly appreciated !
Thanks,
Adam

 

[Jerry Whittle]

The first problem is that much data could quickly overwhelm Access with its 2
GB limit. You might need another database solution like SQL Plus.

MDX files seem to be a database index file. Are you sure that there aren't
other files with extensions like DBF?

Doesn't the new system have tools to query the data?

I would recommend importing similar data into one table. If there is
something like a Date stamp in each record, that would make it very easy.

 

[PieterLinden via AccessMonster.com]

The first problem is that much data could quickly overwhelm Access with its 2
GB limit. You might need another database solution like SQL Plus.

MDX files seem to be a database index file. Are you sure that there aren't
other files with extensions like DBF?

Doesn't the new system have tools to query the data?

I would recommend importing similar data into one table. If there is
something like a Date stamp in each record, that would make it very easy.

MDX is an Analysis Services (SQL Server) database. You should probably post
your question in the SQL Server group and see what you find. (Hey, Aaron,
you could chime in here... provide some useful advice instead of the usual
bashing...)

 

[Korski]

My apologies, It is an MXD file extension.

MDX is an Analysis Services (SQL Server) database. You should probably post
your question in the SQL Server group and see what you find. (Hey, Aaron,
you could chime in here... provide some useful advice instead of the usual
bashing...)

--



.