Lukket

Import csv file using access vb code

I have the following access query

INSERT INTO Boyd0004Books ( LOCALSKU, Warehouse, QOH, QOO, DiscountKey, Retail, Returnable )

SELECT [0004Books].LOCALSKU, [0004Books].Warehouse, [0004Books].QOH, [0004Books].QOO, [0004Books].DiscountKey, [0004Books].Retail, [0004Books].Returnable

FROM 0004Books

WHERE ((([0004Books].LOCALSKU) Is Not Null) AND (([0004Books].Warehouse) Is Not Null) AND (([0004Books].QOH) Is Not Null) AND (([0004Books].QOO) Is Not Null) AND (([0004Books].DiscountKey) Is Not Null) AND (([0004Books].Retail) Is Not Null) AND (([0004Books].Returnable) Is Not Null));

Where 0004Books is a link to a .csv file, and Boyd004Books is a linked table to a SQL database.

I need a vb code written to

import the 0004books file at the '[url removed, login to view] line.

Forms("UpdateStatusForm").Repaint

'[url removed, login to view] "A0004-02A Add 0004Books", acViewNormal, acEdit

Forms("UpdateStatusForm").Controls("status2").Value = "2 of 5"

If you are hard coding the location of the file, then I need it to verify that the file is there, if not, then I need it to try a different location. (I run the file on a network so I'd need to account for the C or the Z location of the file.

Z:\SupplierData\0001Btol

C:\Webfiles\0001Btol

are the 2 folders

Should be a very simple project,

Færdigheder: Visual Basic

Se mere: code import csv access, import csv code access, vb coding, csv file, access d, access query table, using access, access table query, access linked table, table csv, simple project using database, database warehouse, csv table, table linked access, access sql query, line csv, sql query access, simple visual access project, sql visual basic 2012, sql file csv, csv coding, csv file code, access database code, csv import sql database, simple warehouse

Om arbejdsgiveren:
( 7 bedømmelser ) Youngstown, United States

Projekt-ID: #4054817

10 freelancere byder i gennemsnit $121 for dette job

aarrsoftware

Thanks for posting this project on freelancer.com and giving us an opportunity to bid on it. We are a team of software professionals and designers. Our team members have varied experience of software development from 2 Mere

$250 USD in 10 dage
(10 bedømmelser)
4.8
AmirAly

Greetings sir , Kindly Check PMB

$50 USD in 2 dage
(9 bedømmelser)
4.4
ultrasonicsoft

Hi, I can deliver you this project. Please check inbox.

$100 USD in 5 dage
(1 bedømmelse)
2.0
Alld

Hi Dear, i have 8 years of Experiance in Vb and Data Migration. Plz if u are intrested get back to me by Skype. Thanks Ali

$240 USD in 3 dage
(0 bedømmelser)
0.0
thenomader

Respected Sir or Madam, I understand your needs and I am ready to start right now if you give me the chance to work with you. Your satisfaction is my goal. Thanks

$145 USD in 3 dage
(0 bedømmelser)
0.0
rakeshsoft206

I am expert in and can do it.

$150 USD in 2 dage
(0 bedømmelser)
0.0
johndwalton2012

Greetings, I have seen your posting here on Freelancer, and I am interested in your project. I am a full-time freelancer with 17 years of experience developing Microsoft Access Solutions. You are correct in s Mere

$62 USD på 1 dag
(0 bedømmelser)
2.0
abhishek6248

i will be done in 2 days

$30 USD in 2 dage
(0 bedømmelser)
0.0
developer0106

Hi, I can do it for you. Please check PM for more details. Thank you.

$30 USD in 2 dage
(0 bedømmelser)
0.0
nsumaya

Consider your requirement done. I worked with similar scripts during my previous projects. I can assure you that I can do the job in specified time with emphasis on quality and quality!.

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

Hi started my career as freelancer now, i have 14yrs of experience in developing web and stand alone systems using .net

$180 USD in 25 dage
(0 bedømmelser)
0.0