Access 2007 - Exporting TAble Contents to Excel 2007 Spreadsheet
Hi All,
I have seen this question posed all over online and yet none of the answers that seems to work for others actually works for me! What I am trying to do is EXPORT the contents of an Acees 2007 Table to an Excel 2007 spreadsheet in XSLX format.
As you can see my Table Name is "JournalRequest" and I have hard-coded the path to the Output File I want to create.
I CAN achieve outputting my data to other Text Files (CSV, TXT) formats using Export Specifications I create. BUT I *think* that there HAS to be a way to do what I'm attemption. Help!
Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.
1. First you are never stating what actually happens when it "Does not work"
Nothing happens?
Wrong output format?
Access Crashes?
Error message?
You will get some type of read only error, and the Export will "Not Work" when you spell the extension incorrectly as you have done in the code you posted.
Please correct this misspelling and tell us if that fixes this issue.
Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.