Alaska Software Inc. - Excel 2007
Username: Password:
AuthorTopic: Excel 2007
Scott KriseExcel 2007
on Wed, 03 Feb 2010 09:34:51 -0500
Hi Everyone,

I recently installed office 2007 and found that you can no longer use it to 
view DBF tables.  Its been a big selling point of my software to be able to 
export information to Excel...so I'm wondering how to accomplish this in 
office 2007 and beyond? At this point, I have a number of DBF tables being 
created in formats that are useful to the customers...and I want to keep the 
tables in as similar a format as possible in excel.

Thanks,

Scott
Jack Duijf Re: Excel 2007
on Wed, 03 Feb 2010 18:17:22 +0100
Hello Scott,

I just tried this, in Excel 2007.
I can open DBF files without problem, and view them as rows and cols.
Just need to set "All files" in the fileselector.

Regards,
Jack Duijf



Op 3-2-2010 15:34, Scott Krise schreef:
> Hi Everyone,
>
> I recently installed office 2007 and found that you can no longer use it
> to view DBF tables. Its been a big selling point of my software to be
> able to export information to Excel...so I'm wondering how to accomplish
> this in office 2007 and beyond? At this point, I have a number of DBF
> tables being created in formats that are useful to the customers...and I
> want to keep the tables in as similar a format as possible in excel.
>
> Thanks,
>
> Scott
Scott KriseRe: Excel 2007
on Wed, 03 Feb 2010 13:04:59 -0500
Hmm...You're right!

I tried this the other day, and it wouldn't open it.  I then looked under 
"SAVE AS", and found DBF files were no longer listed. After I saw that...I 
googled it and found some documentation that DBF's were no longer being 
supported...so I didn't try again.

I just tried now, and it is opening the table without a problem.

I googled it again and found that you can open dbf tables, but you can no 
longer save in the DBF format. That must be what I read the other day.

Thanks for the help.

Scott

"Jack Duijf" <jack@jdsoftware.nl> wrote in message 
news:2f3aa9fe$404b53d5$6daa2@news.alaska-software.com...
> Hello Scott,
>
> I just tried this, in Excel 2007.
> I can open DBF files without problem, and view them as rows and cols.
> Just need to set "All files" in the fileselector.
>
> Regards,
> Jack Duijf
>
>
>
> Op 3-2-2010 15:34, Scott Krise schreef:
>> Hi Everyone,
>>
>> I recently installed office 2007 and found that you can no longer use it
>> to view DBF tables. Its been a big selling point of my software to be
>> able to export information to Excel...so I'm wondering how to accomplish
>> this in office 2007 and beyond? At this point, I have a number of DBF
>> tables being created in formats that are useful to the customers...and I
>> want to keep the tables in as similar a format as possible in excel.
>>
>> Thanks,
>>
>> Scott
AUGE_OHRRe: Excel 2007
on Wed, 03 Feb 2010 20:50:11 +0100
hi,

> I googled it again and found that you can open dbf tables, but you can no 
> longer save in the DBF format. That must be what I read the other day.

use activeX to tranfer Excel Cell to DBF Fields

greetings by OHR
Jimmy
Ronald van Veelen Re: Excel 2007
on Mon, 08 Feb 2010 09:38:08 +0100
Op Wed, 03 Feb 2010 20:50:11 +0100 schreef AUGE_OHR:

> hi,
> 
>> I googled it again and found that you can open dbf tables, but you can no 
>> longer save in the DBF format. That must be what I read the other day.
> 
> use activeX to tranfer Excel Cell to DBF Fields
> 
> greetings by OHR
> Jimmy

Hi,

I think this is the best option, because the date format of DBF tables is
misread by excel 2007.

Good luck!