Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open DBF files in XL2007
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open DBF files in XL2007
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. "Stephane" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open DBF files in XL2007
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. -- Regards, Tom Ogilvy "Stephane" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xl2007 password to open | Excel Discussion (Misc queries) | |||
XL2007 - Can't open a file that is in use on the network | Excel Discussion (Misc queries) | |||
Add csv to Open "All Excel Files" (XL2007) | Excel Discussion (Misc queries) | |||
There's no export to dbf files from XL2007? | Excel Discussion (Misc queries) | |||
Note on downloading XL2007 files | Excel Discussion (Misc queries) |