Hey
I'm not sure if this is the right forum for this, but I thought it was the most suitable one.

I have a question regarding automating a certain process:

I have a txt file that I import to Excel (as fixed width file, and changing some of the import settings) change certain fields in Excel
Then import that Excel File into Access and perform a single query, the result back to excel, a simple change of one field

I need to perform this every week, my question is if there is any way to do that automatically

Any links to useful info would be appreciated, I must emphasize I know almost nothing about automation with Office

Thanks in advance
Elad

Elad,

You can read your text file in Access, load it to a table, run your query and export it back to excel. All with VB.

1. Is the text file always in the same format?
2. Are the fields in the text file fixed with, or delimited?
3. What are you changing in excel before you import the excel file to access?

Kevin


dartcoach

Hey Kevin

My text file is always the same format, and fixed width
In Excel I only remove two lines after the import takes place (which won't make any problem if I won't because it will disregard it in access)

Problem with the fixed width is that sometimes it adds extra separators I don't need like separating the date into 3 different fields (day, month, year) instead of having the whole 3 in the same field, which is very easy to take care of manually


Thanks again for your reply
and sorry it took me a while to answer
Elad