Lukket

MS Access work needed

Hello,

I have a quick project I need some work on. It is in ms access (db, forms, macros) – the database, forms, and coding.

I have a template table in an access DB, which contains about 20-30 columns. Access should allow the user to browse and select a txt file on their pc to import into the database into the correct fields.

The text file will generally have only 5 columns and those should be imported to the database. The import utility in ms access is retarded and thus a more advanced one is needed where you read a line from the text file and then you insert into the database.

Before importing the text file into the access db, the user should be allowed on the same form to add values for other fields which are not in the text file.

Here is an example:

The table contains the following columns : title, UPC, description, price, shipping, insurance, handling…

The text file contains the following: UPC, price, description, shipping.

I should be able to open the db then goto forms, open up a form where I can browse and select the text file, then on the same form I have the rest of the columns that are not in the text file to edit such as in our example insurance and handling.

I should be able to set those to let's say 2 and 1, and then click a button where a macro or module reads from the text file UPC, price, description, and shipping, puts them in variables and then does an insert UPC, price, description, shipping, handling and insurance. Handling and insurance will be the same for all inserted objects.

The estimated delivery time for this project should not be more that 2 days.

Good luck

Færdigheder: Visual Basic

Se mere: work values, work c, work browse, upc insurance, project work example, ms access work, line coding, import ms project, coding project work, access db forms, access database module, work up, text macros, ms project price, Work, text work, ms s, ms access, line work, database needed, C# access, c access, access, access c#, insurance template access

Om arbejdsgiveren:
( 9 bedømmelser ) Beirut, Lebanon

Projekt-ID: #111051

29 freelancers are bidding on average $74 for this job

HussienSharaf

Hi; i m the best expert with MS Access. plz check my profile. thanks

$90 USD in 4 dage
(40 bedømmelser)
6.3
pgcoding

pl check pmb.

$100 USD in 7 dage
(3 bedømmelser)
6.0
schandraram

Hello Please see PMB for details of my bid. Thank you

$100 USD in 2 dage
(55 bedømmelser)
5.9
rajanlengde

Will be done.

$50 USD in 2 dage
(26 bedømmelser)
5.1
ExactSystems

Please see detail on PMB. Regards, Asghar

$95 USD in 2 dage
(4 bedømmelser)
4.1
Kingpin1962

Kindly check PMB. Thanks...

$70 USD in 3 dage
(3 bedømmelser)
3.8
momleetech

We can do it

$100 USD in 10 dage
(8 bedømmelser)
3.7
shreesoft

Lets Start. Regards Govind

$100 USD in 3 dage
(2 bedømmelser)
1.6
sensen

Hi,We are ready to do now. Feel free to ask more details. Thanks.

$100 USD in 2 dage
(0 bedømmelser)
1.0
Leela19

Please check pmb, Hope the best,Leela Vinotha.B

$75 USD på 1 dag
(0 bedømmelser)
0.0
Nirmlaya

Let's Start & Finsih. Pls send me mock file

$30 USD på 1 dag
(0 bedømmelser)
0.0
dchapiesky

We use Office XP Developer and have about $3000 in books on Access. It's a pain to work with. Your right the importer is dumb as hell. We wrote an access application for a petroleum distributor which had to read a te Mere

$100 USD in 2 dage
(0 bedømmelser)
0.0
pwenghon

I had experience in MS Access Database and programme like some software format. I used to have many software created for office and own use.

$30 USD in 7 dage
(0 bedømmelser)
0.0
DevLalit

I Will Do It, If You Arev Give It To Me.

$45 USD in 3 dage
(0 bedømmelser)
0.0
hyk2005

Hi, i've been around with MS Access for 12 years. Please contact me via email. Regards, Herman

$90 USD in 3 dage
(0 bedømmelser)
0.0
Qasimali84

I am myself expert of Database Programming in Visual Basic using MS Access. And I also have expert team having wide experience of database programming

$100 USD på 1 dag
(0 bedømmelser)
0.0
cmsajithJobs

This project doesnt need much effort and can be delivered within two days. Please check my profile.

$50 USD in 2 dage
(0 bedømmelser)
0.0
suvigya2006

i am a full time freelancer having an exp. of more than 2 yrs in application programming and expertise in vb6, vb.net, access, mssql and as.net. i propose to provide you with a solution in vb.net 2005. the delivera Mere

$50 USD in 2 dage
(0 bedømmelser)
0.0
amkad

Ready to start. WBR

$60 USD in 2 dage
(0 bedømmelser)
0.0
saifbuet

pls send me some txt file related to this work. thanks

$30 USD på 1 dag
(0 bedømmelser)
0.0