vba - Automating import of an Excel file -


i trying import file, saved in our public drive, access database table.

this have far.

dim timestamp2 string timestamp2 = month(date) & "." & day(date) - 1 & "." & year(date) dim xlfile string, shtname xlfile = "open orders @ " & timestamp2 & ".xls" shtname = "current open orders"  docmd.transferspreadsheet aclimport, acspreadsheettypeexcel12, "open orders yesterday", "\\cletus\knxgendb$\daily order bookings\open orders @ " & timestamp2 & ".xls", true, shtname & "!"

this error i'm getting:

run time error 2306: there many rows output, based on limitation specified output format or microsoft access

here specific fixes:

  1. fix file extension. in 1 place have ".xlsx" , in another, ".xls"
  2. correct spelling of acimport (in code incorrectly spelled "aclimport")
  3. to delete table before import, try docmd.deleteobject actable, "open orders yesterday"
  4. when dimensioning multiple variables on same line, have provide variable type each or use default of variant. in case write dim xfile string, shtname string
  5. you don't use xfile variable. should either remove or add docmd.transferspreadsheet line avoid confusion.

and here together:

dim timestamp2 string timestamp2 = month(date) & "." & day(date) - 1 & "." & year(date) dim shtname string shtname = "current open orders"  'delete existing table docmd.deleteobject actable, "open orders yesterday"  'import data, recreating table docmd.transferspreadsheet aclimport, acspreadsheettypeexcel12, "open orders yesterday", "\\cletus\knxgendb$\daily order bookings\open orders @ " & timestamp2 & ".xls", true, shtname & "!"

one question: sheet name "current open orders!"? if not, want remove exclamation mark end of docmd.transferspreadsheet aclimport, acspreadsheettypeexcel12, "open orders yesterday", "\\cletus\knxgendb$\daily order bookings\open orders @ " & timestamp2 & ".xls", true, shtname & "!"


-

Comments

Post a Comment

Popular posts from this blog

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more