Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > Access-L Developer's Libraries > Hibbs, Peter
  New Posts New Posts RSS Feed - Excel to Access Converter Utility program
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Excel to Access Converter Utility program

 Post Reply Post Reply
Author
Message
Peter Hibbs View Drop Down
Contributor
Contributor


Joined: 29 Jun 2008
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote Peter Hibbs Quote  Post ReplyReply Direct Link To This Post Topic: Excel to Access Converter Utility program
    Posted: 10 Jul 2008 at 4:48am
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 2003 (not tried it on Access 2007).

Download A2003: uploads/20/Excel-Access_Converter.zip

--

Email: pdh_software@btinternet.com
This software is freely available to any Access user.
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.