Hibbs, Peter - Excel to Access 2000-XP Converter Utility program

Print Page | Close Window

Excel to Access 2000-XP Converter Utility program

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Hibbs, Peter
Forum Description: Peter Hibbs's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=183
Printed Date: 16 Apr 2024 at 5:58pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: Excel to Access 2000-XP Converter Utility program

Posted By: Peter Hibbs
Subject: Excel to Access 2000-XP Converter Utility program
Date Posted: 10 Jul 2008 at 4:49am

This utility program allows you to convert an Excel spreadsheet file which contains 
'flat-file' data into one or more tables in an Access database. The program creates 
primary and foreign keys in the tables so that 'One to Many' or even 'Many to Many' 
related tables can be created automatically. You just import the Excel file into the 
program, create a template which tells the program which columns in the 
spreadsheet should be copied to which fields in which tables, click a button and 
the program will extract the data into a series of separate tables which can then be 
exported to a new database via .csv files. The program can also be used to create 
properly 'normalised' tables from data in MS Works or any other database by first 
exporting the data to an Excel spreadsheet (or .csv file which can then be imported 
into Excel). Full instructions are included.
 
Version.
This version runs under Access 2000 and Access XP (2002).

Download A2000-AXP: http://www.rogersaccesslibrary.com/forum/uploads/20/Excel-Access_Converter_2000.zip - uploads/20/Excel-Access_Converter_2000.zip

-------------
--

Email: mailto:pdh_software@btinternet.com - pdh_software@btinternet.com
This software is freely available to any Access user.