Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL files saved from Business Objects

Status
Not open for further replies.
MartinF

MartinF

Technical User
Sep 19, 2000
143
FR
Hi,

I often run reports on Business Objects to retrieve data from an Oracle database, however more often than not i have to ammend the data, which i do on Access. What i would like to know is how can i run the SQL statement generated from Business Objects. I can save the statement as an SQL file, and i can connect Access upto the oracle database but i dont know whether or not i can run the query.

Any help would be greatly appreciated.

 
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
568
Andrzejek
Andrzejek
BugZap13
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
222
mikrom
mikrom
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
615
Swi
Swi
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
3K
lameid
lameid
serino
  • Locked
  • Question
Help with SQL inner join statement 1
Replies
2
Views
273
serino
serino

Part and Inventory Search

Sponsor

Back
Top