I am importing data from Excel into Access. The Excel data is slightly corrupted. If the below code is run from within Excel over the data about to be imported into Access, Access imports the data with no problems.
What I want to be able to do is run the code from Access on any workbook and named range the user enters. This will give me the ability to fix the corrupted data right from Access with out going into Excel first.
Any help on this? See code below that is currently run from within Excel.
Do While IsEmpty(ActiveCell.Value) = False
If IsEmpty(ActiveCell.Value) = False Then
Selection.TextToColumns Destination:=ActiveCell, DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True