Formatting text-delimited Excel sheet on import?

[Smoothcat74]

Hi all,

Each day I have an Excel-format sheet which I need to spend considerable time formatting using text-to-columns prior to importing it into my Access database. I would love to be able to automate the formatting of the this sheet either within Excel (prior to the import) or within Acess (during the import.)

Is such a thing possible? What commands in VBA might help me sort this out?

thanks in advance.

 

[SkipVought]

Hi,

Is your data in Excel, not properly parsed?

Where is the source data for Excel? Is it a text file? Maybe a .csv?

Why bother importing the text file into excel before Access. Just import the text file into Access, bypassing Excel.

Need a bit more info on where and what the source data for Excel is.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}