Access Database Consultants, Programmers and Developers


We build, fix and program Access Databases

- $50/hr Questions/Answers & Fixes

- Punch List scoping and Pricing

- Free quotes and quick turn around

Importing Data Files

Importing Data Files

Repetitive data file import is a very common task in Access databases. Oftentimes, the source is a .csv file (comma separated value). But there are lots of other data files that we've imported including Excel files, Quickbook files, SAP files


Here are some clients we have helped:

Client

Location

Project Description

Old Dominion Controls, LLC

Richmond, VA

Old Dominion Controls: Over 25 years of serving the natural gas industries of Virginia and Tennessee. We provide instrumentation and control equipment from the wellhead to the end user in the natural gas world.

CSG Store

Richmond, VA

CSG Store is a Verizon Product Reseller. They were challenged with tracking 1000s of invoices against a series of multiple payments by their clients (various verticals in the chain). We converted their spreadsheet nightmare into an Access Database. They can now process a month's worth of invoices in literally 5 minutes whereas the process was previously taking 3 mandays. This is the type of efficiency you can receive by using Microsoft Access.

From the CSG Store website: CSG Store At Connected Solutions Group, we have a simple belief that every wireless hardware deployment has a sensible and significantly more affordable solution just waiting to be unearthed. With nearly a dozen years of experience directly inside the downstream trade of wireless technology, our ownership prides itself on problem-solving, cost-effective, and innovative ways to bring your hardware application to life.

Other Access Solutions for Communications clients:Expert Access Solutions for Communications

Our Clients Include:

  • The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
    The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
  • The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
    The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
  • Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
    Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
  • Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database
    Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database