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.


'[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.



are the 2 folders

Should be a very simple project,

Evner: Visual Basic

Se mere: code import csv access, import csv code access, VB coding, import sql, import csv, 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, import csv database

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

Projekt ID: #4054817

10 freelancers are bidding on average $121 for this job


Thanks for posting this project on 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 Flere

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

Greetings sir , Kindly Check PMB

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

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

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

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)

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)

I am expert in and can do it.

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

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 Flere

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

i will be done in 2 days

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

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

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

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)

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)