Automatic CSV Upload

• • Reply

  15 years ago

  by nbuckwheat

  nbuckwheat

  , United States

  Joined 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.
  Nancy

  Report abuse