Search results

Hmm...got your point. Could you please let me know how to do it in access. have got some experience in Excel macro, but have got no idea about access. By the way the requirement is as follows:- We have got a data extract screen in excel where user extracts various forms of data. Most of the...

The requirement is such that we have to have a button in excel , clicking on which should do the import of data from CSV to MSAccess.... Does it overwrite the data currently existing in table. Plz give some sample code for the same.

thanks for the reply. Actually what i wanted to is write a macro is in excel which on click of a button is supposed to import the CSV file to a table. Queries I had are:- 1)Is it advisable to import such huge volums of data through Docmd.TransferText method? As of now I used to get the data in...

Hi All, I have got a requirement that I need to import a large CSV file with more then 80k records with some 14 columns to a table directly in MSAccess. I am a newbie (basically a business analyst so not much coding experience)in MSAccess, so have got no idea whether its possible to implement...