(Msg. 1) Posted: Thu Sep 03, 2009 3:05 pm
Post subject: Excel 2003 to Access 2007 Archived from groups: microsoft>public>access>gettingstarted (more info?)
Hi
I'm trying to create a local qube using Excel 2003 (this feature has been
removed in Excel 2007). Thus, I'm trying to connect from Excel 2003 to
Access 2007 .accdb file. How can I do that? When I click Data, Import
External Data > New database query and select Ms Access and then navigate to
file I get a message that .accdb is unrecognized database format.
"IgorM" <igorm.DeleteThis@live.com> wrote in message
news:ueuL0IMLKHA.4608@TK2MSFTNGP02.phx.gbl...
> Hi
>
> I'm trying to create a local qube using Excel 2003 (this feature has been
> removed in Excel 2007). Thus, I'm trying to connect from Excel 2003 to
> Access 2007 .accdb file. How can I do that? When I click Data, Import
> External Data > New database query and select Ms Access and then navigate
> to file I get a message that .accdb is unrecognized database format.
>
> Kind regards
> Igor
>
(Msg. 3) Posted: Fri Sep 04, 2009 2:05 pm
Post subject: Re: Excel 2003 to Access 2007 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi
I tried to do the same in mdb. But there were some errors with a function in
one of my queries.
I will write about them in a new message.
Kind regards
Igor
"Douglas J. Steele" <NOSPAM_djsteele.DeleteThis@NOSPAM_gmail.com> wrote in message
news:OJWJwaMLKHA.5956@TK2MSFTNGP03.phx.gbl...
> Since Excel 2003 was released before the accdb format was defined, I don't
> believe it's capable of reading that file format.
>
> Can you work with an MDB file instead? (Access 2007 is fine with them...)
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele > (no e-mails, please!)
>
>
> "IgorM" <igorm.DeleteThis@live.com> wrote in message
> news:ueuL0IMLKHA.4608@TK2MSFTNGP02.phx.gbl...
>> Hi
>>
>> I'm trying to create a local qube using Excel 2003 (this feature has been
>> removed in Excel 2007). Thus, I'm trying to connect from Excel 2003 to
>> Access 2007 .accdb file. How can I do that? When I click Data, Import
>> External Data > New database query and select Ms Access and then navigate
>> to file I get a message that .accdb is unrecognized database format.
>>
>> Kind regards
>> Igor
>>
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other