Manipulating a spreadsheet

[KenHigg]

I have a spreadsheet that comes in every week from SAP and I always have to open it and delete certain rows and fix a data cell here and there before my MS Access import routine will work. I was wondering if I could, in Access, add some code that would do all of this automatically?

Pseudo code would be something like:

open myXLS
trim spaces off of data in cell d21
delete rows 1 and 2
etc,

???
ken

 

[Brianwarnock]

Would it be easier to do this with an EXCEL macro?

Brian

 

[KenHigg]

Would it be easier to do this with an EXCEL macro?

Brian

Well.... I'm trying to do this with a little effort as possible. What I would like to do is simply run the SAP export, take that xls and put it in a pre-determined folder, th open my Access db and push a button.

Seems if I use an Excel macro I'd have to open the xls and do some more stuff...

???
ken

 

[Brianwarnock]

OK I think I can see what you are saying , so I will leave it to those who know.

Brian

 

[Wayne Cramer]

I use SAP output to Excel to Access back to Excel each day and I have to agree with Brian. Sometimes you just have to use the correct tool for the job and Excel is much quicker and better at formatting SAP output than Access - especially if you have to reformat dates. So, push two buttions - one for the Excel macro and one for the Access import of the data.