Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access External data > Ex****t to spre...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 10835 of 11313
Post > Topic >>

Ex****t to spreadsheet error, help please

by "ljg" <ljg@[EMAIL PROTECTED] > Jul 25, 2008 at 08:27 AM

I am trying to Ex****t to a spreadsheet using the following code, but I keep

getting  error

"Run-Time error '2302' Can't save the output data to the file you've 
selected."

This is my code:

DoCmd.OutputTo acOutputQuery, "propertyrequest", acFormatXLS, 
"C\datastream\ex****t_data\Property" & "_" & UsrName & ".xls"

I am assuming its the file format? I am using Access 2007, in a 2002 -
2003 
format and using Excel 2007 set to save in Excel 97 - 2003 format.

I am running Vista Ultimate.

Any help would be most welcome.
 




 3 Posts in Topic:
Export to spreadsheet error, help please
"ljg" <ljg@[  2008-07-25 08:27:42 
Re: Export to spreadsheet error, help please
"Jeanette Cunningham  2008-07-25 19:17:50 
Re: Export to spreadsheet error, help please
Ron2006 <ronnemec@[EMA  2008-07-25 05:33:14 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 18:42:33 CST 2008.