(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 2 [3]  Send Topic Send Topic Print Print
Very Hot Topic (More than 25 Replies) ODBC (Read 5861 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: ODBC
Reply #30 - Dec 10th, 2009 at 9:07pm
Print Post Print Post  
Hello ray,

i use the MS Office 2007.

Thanks.
  
Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: ODBC
Reply #31 - Dec 10th, 2009 at 9:15pm
Print Post Print Post  
In Excel 2007
Start a New Workbook
Click the Data Tab
Click From Other Sources
From the Drop Down, Click "From Microsoft Query"
Choose the same ODBC link that you were choosing from Crystal Reports

Can Microsoft Query show the fields from the Invoice Database?

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: ODBC
Reply #32 - Dec 16th, 2009 at 8:45pm
Print Post Print Post  
Hello Ray-

In Excel i could not open files and got this error :"there were no Tabellists from Source Database obtained!"

In Crystal Reports just a few forms are not open (Is the reason perhaps to certain Form characteristics?)

Thanks.

Dr. Belhareth
« Last Edit: Dec 17th, 2009 at 9:12am by Amor »  
Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1 2 [3] 
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge