SQL Statements...where?

[OfficeUser]

Are SQL statements typically contained in the same area in an database? If so, where might be a good place to look? Thanks.

 

[Joe4]

I am not really sure what in what context you are referring to, but each Query in Access is stored as SQL statements. To see this, highlight any Query and change to SQL View and it will show you the SQL code for that Query.

Is that what you are looking for?
If not, please provide more detail on exactly what you are after.

 

[OfficeUser]

I am dumping data into excel and need to use a statement to do so. I think I will leave it alone. Thanks for your insight.

 

[Joe4]

I think that would require a Macro or VBA, not necessarily SQL.
You can use the TransferSpreadsheet Macro Action to send an Access Table or Query to an Excel file.

 

[OfficeUser]

I talked to the individual who maintains our db here and the write statement in something I do not have access to then they implement it into the database and pass me the statement i need to dump all required data in an excel sheet at which I use vba to get it into the form I would like. I really don't know Access, I have made databases, but nothing like this.

 

[Joe4]

I am sorry, but I am not understanding what you are saying.

Just what exactly are you looking for/asking?

 

[OfficeUser]

I open Excel, Import External Data, New Database Query. I then close until I get to the Edit In Microsoft Query, click on the SQL box, input my statement (which I don't have the correct one) and then I return data to excel...

I am reading up on the TransferSpreadSheet Macro.

 

[Joe4]

Ah, you are involing Microsoft Query. I am afraid I cannot be much help with that. I know Excel and Access, but not MS Query.

 

[OfficeUser]

I know the feeling....

 

[Alex O]

Joe4<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I was reading through the forum and stumbled across this entry. Would you care to expound on this? I wasn't aware such a thing was possible...how exactly would you perform this action?<o></o>
<o></o>
I think that would require a Macro or VBA, not necessarily SQL.
You can use the TransferSpreadsheet Macro Action to send an Access Table or Query to an Excel file.