Importing Excel column to Access

[MUKESHY12390]

Hi All,

I got situation where I have import column from Excel to Access.

But there are some Challenges in Excel File which are.


1) column does start from First row and total I have 42 columns, It starts from 20.

2) I want to import only 5 column.

3) between 42 column there are some columns are Blank has not Field Name.


So I just need advice what is the better solution in this scenario.

Any help would be appreciate.


Thanks,
Mukesh Y

 

[Joe4]

Try naming the range you want to import in Excel.
Then, when importing, you have the option of importing by named range. So you can then import just the information you want.

 

[MUKESHY12390]

I have around 130 files with same structure and format I have mentioned below.

 

[Joe4]

I would put them in a single folder, and then create an Excel macro to loop through all the files and copy and paste the needed data to a single file, and then import that file.

 

[MUKESHY12390]

thanks !! that's that I was thinking.

 

[Joe4]

You are welcome!