Open DBF files in XL2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stephane - 15 Feb 2007 13:19 GMT

Hello,
I would like to open a DBF file in XL. In this file, I have some Date fields
in format "AAAMMDD" (ex: 20070215 for today). In XL 97 or 2003, when I open
this file, the date fields are recognize and in the cell the date is in
format (DD/MM/AAAA as it is a french system). But in XL2007, this format is
not recognize and the field is a text one (20070215)
Is there any change in the import filter of the dbf files between XL2003 and
XL2007?
Can I change some parameters in the filters?
Thanks for your help.
Stéphane.

Reply to this Message

Joel - 15 Feb 2007 14:49 GMT

copy the DBF file to a new name so the old file doesn't get changed. the try
saving the DBF file in diffferent formats (access 97 access 2003). I think
when you open the dbf file it will automatically get convertered to 2007.
Access needs to be converted to work witth different versions of office.

> Hello,
> I would like to open a DBF file in XL. In this file, I have some Date fields
[quoted text clipped - 7 lines]
> Thanks for your help.
> Stéphane.

Reply to this Message

Tom Ogilvy - 16 Feb 2007 01:09 GMT

Support for dbf was deprecated in xl2007. As I recall, it can still read
it, but not save as dbf. maybe use get external data.

Signature

Regards,
Tom Ogilvy

> Hello,
> I would like to open a DBF file in XL. In this file, I have some Date
[quoted text clipped - 7 lines]
> Thanks for your help.
> Stéphane.

Reply to this Message