Ask Your Question

Access2Base Output Command failure [closed]

asked 2016-04-14 22:45:47 +0200

Michel_1495 gravatar image

Hello, I use access2base & I want to export data (tables& queries) from the (Mysql) membership database. Since my previous experience (bug in DLookup Mysql) I now try first in a base file with the HSQL embedded database. I want to export the memberdata & I use the following command:

DoCmd.OutputTo(acOutputTable, "t_Leden",acFormatXLSX, "C:\Users\michel\Documents\Libre Office\leden.xlsx",True,,,)

A error message pops up: Error #1503 (Argument nr. 3 [Value = 'CALC MS EXCEL 2007 XML'] is invalid) occurred in a call to function 'OutputTo'

I discovered only this one was ok, export a open form to a pdf:

DoCmd.OutputTo(acOutputForm, "f_Leden",acFormatPDF, "C:\Users\michel\Documents\Libre Office\Leden.pdf",True,,,)

Have I missed something here?

Thanks for the support


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Michel_1495
close date 2016-04-15 22:39:30.951503

1 Answer

Sort by » oldest newest most voted

answered 2016-04-15 22:39:04 +0200

Michel_1495 gravatar image

OK, I missed this: - Method: Output the data in the specified object (currently only a form) to several output formats.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-04-14 22:45:47 +0200

Seen: 86 times

Last updated: Apr 15 '16