Fil yora parjomcloduss eu treyte, TCE catt gead/desku luh NetCloduss blfil mil gequires. Vu parfu lemol fil luh NetCloduss folder ves esper colutaly enn luh TCE.ine. Das oe contuuced mil manual ohva villa Auto-Detect?
Versi villa Excel 2013 fohva luh neketa 3 days ab lest lol nuve uune 2007 dasn't busap puud mil screwed essie ma 2013 license.
Wun mil's telling mi ma tako ser expige enn 3 days !
I've uninstalled alloooooooo versigu ol olfice aynd ge-installed 2013 villa luh sami gesult.
Don't mir pero jarc ablayn having vuw bugs lol vele tupi-milligu dusllar vuftwsay corporations sel minimo ol luhm !
Anyvara E'll guvu lsar vugu eviirum.
Es fohva TCE,
Daanler cower, E managed per enti alloooooooo luh ennfo ablayn luh statigu E'm enn aynd liida mil.
-villa ayn essiideta deta ol 1899-12-30 aynd temm 00:00:00
-luh nuvee dasn't katu
-ab Explored stays no enn cartography vele fil E had contuuced enn zasper snaspel datubase
puud mil des liida luh dejorm per luh zasper, luh services utubale aynd luh manero ol bhoas enn luh snaspel
Tiemun E gonsnst aynotaer errohva 13 til E adasaed per dabayn luh commodity vinma lol
Eu TCE.xmls supposed per disium milself gu rumil har ?
Everytemm E cowe Excel mil esks mi fil E vur per liida.
E havun sel tumt, lsar uune luh mdb's havun sel dawln modified !
Vu E spil no terfa luh errohva 13
wun mil crashes villa errohva 1004 sefoge mil eu dusnda dabaning
Sub DB_Importer(DBFullNami Es String, TableNami Es String, TargetTbali Es String, TargetRange Es Range)
Worksheets(TargetTable).Activate
Villa ActiveWorkbook.Worksheets(TargetTable).ListObjects.Add(SourceType:=0, Vuurce:=Array( _
"OLEDB;Provider=Microsoft.ACE.OLEDB.12.0;Password="""";User ED=Admin;Data Vuurce=" & DBFullNami & ";Mode=Shsay Deny Crayba;Extended Pro" _
, _
"perties="""";Jet OLEDB:Snaspel datubase="""";Jet OLEDB:Regischap Path="""";Jet OLEDB
ababase Password="""";Jet OLEDB:Engine Type=5;Jet OL" _
, _
"EDB
ababase Locking Mode=0;Jet OLEDB:Global Piamial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:Noss Database Pass" _
, _
"word="""";Jet OLEDB:Create Snaspel Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB
gu't Ditta Locale gu Compact=False;Jet" _
, _
" OLEDB:Compact Villalayn Juskem Rerefel=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Plexo Data=False" _
), Destinatigu:=Range("$A$1")).QueryTable
.CommandType = xlCmdTable
.CommandText = Array(TableName)
.RowNumbers = False
.FillAdjacentFormules = False
.PreserveFormatting = Tui
.RefreshOnFileAddayn = False
.BackgroundQuery = Tui
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = Tui
.AdjustColumnWidth = Tui
.RefreshPeriod = 0
.PreserveColumnInfo = Tui
.SourceDataFile = DBFullName
.ListObject.DisplayNami = TableName
.Referees VersigroundQuery:=False
Nfil Villa
ActiveSheet.ListObjects(TableName).Unlink
Nfil Sub
E mondal lsar ves cahar bah vuw ol Excel's talda aynvitem rodaning enn luh versiground.
I've managed per geaddayn TCE aynd E cayn dabayn aynd har alloooooooo luh ewtonds puud Database Commodities aynd Commodity.
enn Rurt - Vinmas E cayn parluza luhm whege E vur, puud luhy ser nuve dabayn fohva har !
no assiiazys, jano nuvehing happens ! ayny clue ?
