macro to export excel file

[muralikreddy]

Hi,

I have a table in which daily movement of stock into various processes is loaded. The daily movements will be uploaded from an excel file. I want to write a macro to upload an excel file into a table and all the details in the excel file should be uploaded to the table.

 

[Bob-THG]

You would first have to link the excel file into Access.
Then it looks and acts like a table.
From there you just write and run queries against it.

*** Tip - Make sure it is a clean data file.
All column headers are properly named without special characters.
No subtotals and totals.
If you select the columns to the right of the last column and do an edit>delete you will assure that no junk is included.
The same goes for selecting and deleting all the rows below the last data row.

It's just good data prep.

 

[crazyforexcel]

Hi,

Am new to the forum , I have fair idea on Macro - but would need help on VBA code for the below mentioned Issue/Problem .

I have Multiple work books in a folder which i would like to upload into a website (Intranet) based on the defined Criteria in the Website (Its Basically Uploading Account Reconciliation into Website for Review/Approval) Any help or pointers is greatly appreciated