Refreshing Data from .txt file causes change outside data range

L

Linda

I have a simple Worksheet developed to import and format a single record .txt file, which will ulitmately be imported into an Access table. I have to do it this way (I think) because I don't get field names in the .txt file
The first row contains Field Names, and the second row is the data range to be refreshed from the .txt. file
When I refresh the data by selecting the range and chosing Data -> Refresh Data, the values are imported correctly, but my heading row is wiped out (except for the very first cell (A1). What can be causing this

In addition, I will need to automate this completely from Access. Any good reference docsuments to help with this
Thanks.
 
Top