Using the data in the posted Access file, an Access query can generate the 3-column dataset.
As for the import of raw data, the how depends on the source and structure.
Using the data in the posted Access file, an Access query can generate the 3-column dataset.
As for the import of raw data, the how depends on the source and structure.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.