Hey gang, I'm trying to pull data from a CSV file into Access for use in creating various reports. Essentially, I have mapped our UPS program so that it exports shipping data to a CSV file, two computers sending data to one file on the network. From there I have the CSV file linked to an Access database. The goal is to pull this info as well as pulling in related order info from our ordering system and from that generate daily reports. Currently we're just typing information into an Excel file. I'm preferring to automate this a lot more so it's less typing we're having to worry about each day.
Anyway, that's the sum up story. The issue I'm finding now is I'd like to at the end of each day run a query of some sort to send information to a table in Access containing the info from our system as well as from the CSV. From there I'd like to clear out the data in the CSV file but leaving the file. Just to test out the link, I tried selecting a record and deleting it within Access and I was given an error message of "Deleting data in a linked table is not supported by this ISAM."
Any ideas? Or is there another approach I should look at for getting this accomplished?