JazzSP8
Well-known Member
- Joined
- Sep 30, 2005
- Messages
- 1,233
- Office Version
- 365
- Platform
- Windows
Hey All
I've got a Workbook which imports an Access Query using VBA, it's a recorded macro being used to do this;
One of the Fields contains a link to an image URL but for some reason it's getting cut off at certain points. Some examples of this include;
One thing I've noticed is that the minimum length of the affected records in Excel is 70 charcters longs, all records under that are fine (it can get up to 93 characters long though).
One other 'odd' thing I've noticed is that in Access it's being recognised as a URL (blue underlined clickable) but two other fieds which contain a URL aren't and are fine when imported.
The URL's that are being recognised, and cut off come from an imported text file Table - The ones that aren't being recognised as a URL are coming from an imported Excel Workbook Table.
Has anyone come across anything like this before and can help shed some light?
Any help would be greatly appreciated.
I've got a Workbook which imports an Access Query using VBA, it's a recorded macro being used to do this;
VBA Code:
With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array( _
"OLEDB;Provider=Microsoft.ACE.OLEDB.12.0;Password="""";User ID=Admin;Data Source=" & ActiveWorkbook.Path & "\Red Skull.accdb;Mod" _
, _
"e=Share Deny Write;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password=""""" _
, _
";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transaction" _
, _
"s=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't C" _
, _
"opy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=Fa" _
, _
"lse;Jet OLEDB:Bypass UserInfo Validation=False;Jet OLEDB:Limited DB Caching=False;Jet OLEDB:Bypass ChoiceField Validation=False" _
), Destination:=Range("$A$1")).QueryTable
.CommandType = xlCmdTable
.CommandText = Array("Hail Hydra")
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = False
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
.SourceDataFile = ActiveWorkbook.Path & "\Red Skull.accdb"
.ListObject.DisplayName = "Table_Red_Skull.accdb"
.Refresh BackgroundQuery:=False
End With
One of the Fields contains a link to an image URL but for some reason it's getting cut off at certain points. Some examples of this include;
Access | Excel |
One thing I've noticed is that the minimum length of the affected records in Excel is 70 charcters longs, all records under that are fine (it can get up to 93 characters long though).
One other 'odd' thing I've noticed is that in Access it's being recognised as a URL (blue underlined clickable) but two other fieds which contain a URL aren't and are fine when imported.
The URL's that are being recognised, and cut off come from an imported text file Table - The ones that aren't being recognised as a URL are coming from an imported Excel Workbook Table.
Has anyone come across anything like this before and can help shed some light?
Any help would be greatly appreciated.