Ditutup

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,

Kemahiran: Visual Basic

Lihat lebih lanjut: 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

Tentang Majikan:
( 7 ulasan ) Youngstown, United States

ID Projek: #4054817

10 pekerja bebas membida secara purata $121 untuk pekerjaan ini

aarrsoftware

Thanks for posting this project on [url removed, login to view] 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 Lagi

$250 USD dalam 10 hari
(10 Ulasan)
4.8
AmirAly

Greetings sir , Kindly Check PMB

$50 USD dalam 2 hari
(9 Ulasan)
4.4
ultrasonicsoft

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

$100 USD dalam 5 hari
(1 Ulasan)
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 dalam 3 hari
(0 Ulasan)
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 dalam 3 hari
(0 Ulasan)
0.0
rakeshsoft206

I am expert in and can do it.

$150 USD dalam 2 hari
(0 Ulasan)
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 Lagi

$62 USD dalam sehari
(0 Ulasan)
2.0
abhishek6248

i will be done in 2 days

$30 USD dalam 2 hari
(0 Ulasan)
0.0
developer0106

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

$30 USD dalam 2 hari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
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 dalam 25 hari
(0 Ulasan)
0.0