CODEWITHSUNDEEP
excelms-access
Brett G
Brett G

Reputation: 349

Import data file into excel or access

I have an excel file which I've been supplied a layout for with the name, length, start and end positions of each field for a data file. Any ideas on an any easy way to use this layout file to import the data file into its respective fields in access or excel?

Upvotes: 0

Views: 179

Answers (1)

Fionnuala
Fionnuala

Reputation: 91376

Schema.ini ?

http://msdn.microsoft.com/en-us/library/ms709353(VS.85).aspx

Upvotes: 1

Related Questions