Print Page | Close Window

CreateTableFromLinked.mdb (intermediate)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=363
Printed Date: 19 Apr 2024 at 2:36am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: CreateTableFromLinked.mdb (intermediate)
Posted By: Roger Carlson
Subject: CreateTableFromLinked.mdb (intermediate)
Date Posted: 01 Aug 2008 at 6:12am

Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .

CreateTableFromLinked.mdb

This sample illustrates how to create a native Access 2000 table
 from a linked Excel table.  This process can be easily modified to do
the same thing for linked Text or ODBC tables.

Click the button above to do the individual steps in each process. 
These steps could be automated further, but are presented here as
an illustration of the process.  Creating them in steps like this also
allows user intervention at any point in the process.
 
Download
Access 2000 DAO (190 KB):
http://www.rogersaccesslibrary.com/forum/uploads/5/CreateTableFromLinked2k.zip - CreateTableFromLinked2k.zip



-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net