Automatic CSV Upload

access United States
  • 15 years ago

    Hi, Can an expert please help provide a code that will allow an automatic upload of a CSV that will return to an Outlook Inbox?

    My Access database will contain tables for regions, ocean costs, truck costs, etc. The main function of the database is to track shipping costs.

    Various CSV files will come into Outlook from various regions and contain fields for all tables within Access.

    Is it possible to automate a command button in Access the will upload the CSV file and place the data in the appropriate tables without having to restructure the CSV fields to match the Access table structures?

    I'm new to Access so details and "English" will be most helpful. I'm not up to speed with tech terminology.

    Regards and thanks in advance.

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“To iterate is human, to recurse divine” - L. Peter Deutsch