Open .csv with fileDialog then TransferSpreadsheet

[corptkm]

I need to do the following..

1. open .csv on server (Dialog box directly to the server drive S:?)


2. transfer to one Access Table
Export back to same server drive location in .xlsx format.

What is the easiest way.

Ive dont the fileDDialog but all I can do is select it. It needs to open the .cvs so I can transfer (Import) the data to a table before I export back to the sever in .xxlsx format.

Thanks in advance

[pbaldy]

You use the path from your file dialog to link or import the data. Here strPath is a path from a file dialog (I'm linking to it):

DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel9, "ExcelWages", strPath, True