Exporting Tables

[Willy]

Hello,
I'm trying to export a table to an database file, or a .dbf extension. How do I do this within Access 97? I'm doing so that I do not have to waste memory and space on a server to create a new database to hold this table. Any help would be appreciated! Thanks in advance.

 

[Eric Butts [MSFT]]

Hi,

Right click the table and choose Export, for Files of Type select the file
type you are needing to export the table to..


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Thread-Topic: Exporting Tables
| thread-index: AcROUSyrWAXRX/ghSZ+7VEMOipNp6A==
| X-WBNR-Posting-Host: 153.2.247.13
| From: "=?Utf-8?B?V2lsbHk=?=" <[email protected]>
| Subject: Exporting Tables
| Date: Wed, 9 Jun 2004 11:40:02 -0700
| Lines: 2
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.macros
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.macros:32405
| X-Tomcat-NG: microsoft.public.access.macros
|
| Hello,
| I'm trying to export a table to an database file, or a .dbf extension.
How do I do this within Access 97? I'm doing so that I do not have to
waste memory and space on a server to create a new database to hold this
table. Any help would be appreciated! Thanks in advance.
|

 

[Willy]

Sorry, I probably should have been more clear. I'm trying to do this in a macro. This is something that will have to be done weekly and i'm trying to automate it. Thanks again for your help. And thanks for any other suggetions that are given!
Willy

 

[Jim/Chris]

1.
Create a macro using the TransferDatabase action

2.
Use the Windows Task Scheduler to schedule the export on a
specific day/time/frequency. The command would look
something like this. (watch for word wrap)
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\PathToDatabase\database.mdb"/x "MacroName"

Jim

-----Original Message-----
Sorry, I probably should have been more clear. I'm trying

to do this in a macro. This is something that will have to
be done weekly and i'm trying to automate it. Thanks again
for your help. And thanks for any other suggetions that
are given!