P
PeteCresswell
I'm linking to an MS Excel spreadsheet.
One of the columns has a header "TradingAccountNumber", but the actual
data is alphameric.
e.g. Row #1 is "378018FI" and row #5 is "3500390".
In Excel I've done Format | Cells | Number | Category = Text.
But MS Access persists in assigning "Double" to this
column's .FieldSize.
File | Get External Data | Link Tables solicits only whether there is
a column header row or not and the name of the link tb created. It
does not seem to allow for specifying data types on a column-by-column
basis.
Seems to me like I've been able to specify data types in the past.
I'd like to avoid writing an ImportSpec bc I've already got a lot of
code written that is predicated on just opening up the link.
What am I missing?
One of the columns has a header "TradingAccountNumber", but the actual
data is alphameric.
e.g. Row #1 is "378018FI" and row #5 is "3500390".
In Excel I've done Format | Cells | Number | Category = Text.
But MS Access persists in assigning "Double" to this
column's .FieldSize.
File | Get External Data | Link Tables solicits only whether there is
a column header row or not and the name of the link tb created. It
does not seem to allow for specifying data types on a column-by-column
basis.
Seems to me like I've been able to specify data types in the past.
I'd like to avoid writing an ImportSpec bc I've already got a lot of
code written that is predicated on just opening up the link.
What am I missing?