asked on

Import excel CSV into Access at Row 2 and only columns A:L

I am sure there is an easy way to do this. I have an excel spreadsheet that gets dropped each Monday.

I need to automate this file to import into access and dump into our SQL tables. Right now we have to manually delete the first 2 rows (Header and a blank line). The file names are at row 3 and we only need columns A:L. What code can I write that is the easiest way to do this?

I have a screen shot of the actual file after I opened it in excel.
MDD-Image.PNG

ASKER CERTIFIED SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gracie1972

ASKER

My next question is that the data is a common delimited file and there is also numbers with commas separated by commas, is there any way to get around this barrier?

SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

aikimark

Please post a representative sample data set

Gustav Brock

There are no commas on your sample picture. Integers only.

However, if you have comma as the decimal separator, you can simply use CCur to convert:

NetSales: CCur([F8])

/gustav

SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

aikimark

@gracie1972

Where's the sample data file?

PatHartman

@aikimark, Why do you need a sample data file?

@Gracie, Next time please start a new question so you can allocate points fairly.

aikimark

Why do you need a sample data file?

@Pat,
There might be a solution that the other experts haven't offered.