R
Rob
Hi,
Posted for the 2nd time with correction in narrative!
Access 2000, Win XP.
Each week I receive a text file of CSV format that I import in to my Access
database, the weekly file contains around 2,000 records of which each record
has data on 40 fields. Although this works okay, and the Excel Pivot Table
that uses this information functions as expected, the size of the database
is getting somewhat large. I've read about linking text files in Access as
opposed to importing but haven't had any luck in doing this. I also need
the file if linked to function in my Excel Pivot Table albeit I know that
I'll have to set this up differently.
Any advise on this subject would be most appreciated.
Thanks, Rob
Posted for the 2nd time with correction in narrative!
Access 2000, Win XP.
Each week I receive a text file of CSV format that I import in to my Access
database, the weekly file contains around 2,000 records of which each record
has data on 40 fields. Although this works okay, and the Excel Pivot Table
that uses this information functions as expected, the size of the database
is getting somewhat large. I've read about linking text files in Access as
opposed to importing but haven't had any luck in doing this. I also need
the file if linked to function in my Excel Pivot Table albeit I know that
I'll have to set this up differently.
Any advise on this subject would be most appreciated.
Thanks, Rob