Importing new Data into Standard Data tables

[Intermedius]

Hello,

I using a VBA and VBScript to pull data from SAP and saving as a txt/csv file, then importing the data into Excel.

My problem is that i would like to import the data into a data table, but Excel doesn't like to import data into an existing table.

I've played around with connections and queries, but i have not found a solution.

A work around i think may work, but is very sloppy, would be to use VBA to convert the existing table into a normal "Range", import the new data, the re-convert the data range into a data table. Any better ideas?

I am so set on the table because of the awesomeness and simplification of table formulas and their auto-population.

 

[Intermedius]

Any ideas out there?

The issue is i want to overwrite existing data in the table and not add to it. Would a data model solve my issues?

I've tried playing around with it, but i am not sure if it is the solution, as i have similar issues with Access.

I have table formulas on a dashboard sheet, so ideally i'd want to maintain one source table.