Excel macro

[pratapkumar mohapatra]

Hi
how to upload csv file into MS access using macro, I am new in macro. Please anyone help me..

Thanks
Muralidhar

 

[sgmpatnaik]

@pratapkumar mohapatra

Welcome to Chandoo.Forum, Glad you are here

as a new member i would like to request please read the Forum Rules and before any question please search in Google or the Top right side of the Google Search

https://www.google.co.in/search?biw...0....0...1c.1.37.serp..10.24.5559.5JM8Ej-v3dk

please check from the above link, if any problem please come back

Thanks

 

[Pablo]

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "Table Name", CSV Filename