Data Import

[ammu_sridhar]

Hello all,

I need to build a project where I can specify a file path in a form and press "Import" button. Then I need a VB code / macro / module which imports the data in this into a database with columns such as "Emp Id", "Name", "Sex", "Age", "Salary" etc....

My notepad will have all these values as pipe ("|") seperated values, as below.

My notepad file looks like this.

1234|sdfsdf|m|23|4563
4567|dfsdfd|f|25|7456
7823|bgfbh|m|22|3453
9834|sefdfc|f|23|6575

Could anybody help me here.

Sri.

 

[ajetrumpet]

I am not being rude here Sir, but this is very researchable. There is a wizard to do this for you. To get your import button, why dont you try googling a bit on this?

Manually import from Access is.... file > get external data > import