ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   convert excel data to dBaseIII (https://www.excelbanter.com/new-users-excel/233020-convert-excel-data-dbaseiii.html)

Barbara

convert excel data to dBaseIII
 
I am wanting to use a excel data base for Avery mail merge which requires the
info in dBaseIII. I am a Beginner...........

Shane Devenshire[_2_]

convert excel data to dBaseIII
 
Hi,

dBaseIII, haven't heard that one in a long time.

In Excel 2003 or earlier choose File, Save As, and change the Save as type
to DBF 3 (dBASE III) (*.dbf)

Excel 2007 doesn't support that file type.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Barbara" wrote:

I am wanting to use a excel data base for Avery mail merge which requires the
info in dBaseIII. I am a Beginner...........


Barbara

convert excel data to dBaseIII
 
Thank you Shane, 2007 is what I have.

"Shane Devenshire" wrote:

Hi,

dBaseIII, haven't heard that one in a long time.

In Excel 2003 or earlier choose File, Save As, and change the Save as type
to DBF 3 (dBASE III) (*.dbf)

Excel 2007 doesn't support that file type.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Barbara" wrote:

I am wanting to use a excel data base for Avery mail merge which requires the
info in dBaseIII. I am a Beginner...........


Shane Devenshire[_2_]

convert excel data to dBaseIII
 
Hi,

Access 2007 can Export a table as a dBase file. (External Data, More, ....)
So you could import your Excel data and then do the conversion there.

You could download a free copy of OpenOffice and it will allow you to save
the file as a dBase III file.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Barbara" wrote:

Thank you Shane, 2007 is what I have.

"Shane Devenshire" wrote:

Hi,

dBaseIII, haven't heard that one in a long time.

In Excel 2003 or earlier choose File, Save As, and change the Save as type
to DBF 3 (dBASE III) (*.dbf)

Excel 2007 doesn't support that file type.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Barbara" wrote:

I am wanting to use a excel data base for Avery mail merge which requires the
info in dBaseIII. I am a Beginner...........



All times are GMT +1. The time now is 03:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com