Rabu, 14 Oktober 2015

Re: [MS_AccessPros] query must be updateable on transferspreadsheet?

 

Hi Liz,

What is the SQL for "WO Routing Actual vs Standard"?

warm regards,
crystal

~ have an awesome day ~

On 10/14/2015 4:06 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] wrote:

Pros, This is a command from a db that got dumped on me and I don't know why it is breaking.

 

objAcc.DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, _

"WO Routing Actual vs Standard", strName2, True, "Actual Data!" 

 

Gives the error query must be updateable.  Other than someone having the table open, I don't know why it is crashing.

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-4808

beaerospace.com

Passion to Innovate. Power to Deliver

 



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Posting Komentar