Open DBF files in XL2007

  • Thread starter Thread starter Stephane
  • Start date Start date
S

Stephane

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.
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot open dbf file created in Visual Foxpro 7 or 9 in EXCEL 2010 0
Convert date from dbf files 1
Advanced Filter problems using VBA in XL2007 2
Save as DBF 4 2
Xl2007 not unprotecting worksheet!!!! 1
Moving shapes around - XL2007 bug? 1
XL2007 - Known problem? - Driving me crazy. 18
XL2007 - checking build version and applied fixes 4

Back
Top