need VBA code to load data to ACCESS

[srinivas_p]

Hello All,

I have data in my excel file which contains four sheets, these sheets data needs to be loaded into different tables into MS Access, Need to develop VBA code in excel for this.

Thanks & Regards
Sri

 

[Ruddles]

Have you considered importing the data into Access manually or creating linked tables which reference the worksheets directly?

When you say you need to develop the code, do you actually want to write the code yourself or do you want someone to write it for you?

• If the former, show us what you have already.
• If the latter, you'll need to state the names of the tables and list the names of the fields in each of the tables. It will also be helpful to see a sample of the data in each worksheet. When posting sheet samples, review the message before posting to ensure it's deciipherable.

Do the tables already exist or do they need to be created?

• If the tables already exist, do you want to append the data to them or overwrite them?
• If they need to be created, what are the data types of each of the fields?

What version of Office are you using?

What is your level of VBA expertise?

 

[srinivas_p]

Hi,

Thanks for Replying,

I'm good at VBA Programming in Excel not much expertise in MS Access VBA,

For Your Questions

1) Tables already exists, want to append the data to them or overwrite them from Excel sheets by using excel VBA Code, need a code to interact with MS Access.

Thanks & Regards
Sri