Export from Access to Excel with different tab names

[djmousie]

Sorry if this is a repost, I think I posted in wrong forum...

I currently have an Access table that I am trying to use the field data as a means of exporting. For example, I have a table with a field labeled [VENDORS]. There are different vendors within the [VENDORS] table. I would like to export so that it groups the same vendor names together and applies the vendor name to a new excel tab in Excel. So vendor "ABC" and all its corresponding information will be exported to a new tab in Excel called "ABC"...and so on with the next vendor.

Is this possible?

 

[BoxHead]

check your other post

When Galileo theorized that Aristotle's view of the Universe contained errors, he was labeled a fool.
It wasn't until he proved it that he was called dangerous.

 

[coder30]

I have a macro that runs a query that accesses a SQL server table. However when I manually run the query there are no problems, and no login/password is even needed...but when my macro or module attempts to run this query it bombs with 'ODBC-SQL connection failed'. Is there some sort of issue with the jet engine accessing a SQL table and how can I code around it?