Import CSV file into Excel Table

[ElpabloB]

Firstly Hello, and thanks in advance for your assistance !

I'm building a macro that takes a CSV file and imports into an Excel Table.

I've managed to get the dialogue box to prompt the user up and running, can select and open the file, but need assistance with how to import it into my table.

The macro will be inserting a new row at the top of the table each time it imports a CSV, so will always begin pasting into cell G3, with all rows moving down on insertion.

I also don't want to extract the first two rows of the CSV file as they contain header information.

The CSV file is semicolon delimited.

Is anyone able to help ?

[dflak]

It would help us a lot to have two sample files: the file you want to import from (CSV file) and the file you want to import to.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[ElpabloB]

As much as I would love to, the sensitive nature of these documents within the business would not permit me to do this due to data protection, sorry.

[Andy Pope]

Have you tried using the import function under the Data tab.

Data > Get External data > From Text

You can select semicolon delimiter as well has skipping 2 start rows.
The macro record should provide starting code that you can adapt.

If you still need help consider making a couple of dummy example files that illustrate the problem. No need to post actual live data files.