[DXBase] File export to Excel...
Wes (N7WS) and Linda
[email protected]
2002年7月20日 16:04:25 -0700
At 04:57 PM 7/20/02 EDT, [email protected] wrote:
>Hello,
>Per the DXbase archive the suggested method to export the DB to Excel is via
>HTML format. For my database (approx. 20 MB) it creates a very large HTML
>file and for my system (450 MHz Pentium II with 128MB RAM) it takes forever
>to export (plus Excel chokes). Are there other methods to create the XLS
>file that create smaller more manageable files from User Lists? Using the
>export function in the Standard Reports creates XLS files of very manageable
>size and does so quickly.
>73 de Stokley, W3SB
Why don't you just import it directly using Excel.
Go to "Data" -> Get External Data -> New database query and select "MS
Access 97 database. This will open a "connecting to database window and
prompt for the file name. Select your .mdf file (I strongly recommend that
you practice on a backup copy)
From here you can use the wizard to set up the data read into Excel.
Wes N7WS