473,503 Members | 4,272 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Import specific column from excel into access using visual basic 6

22 New Member
Hi experts,
I would like to import data from excel into access. For example I have field "Name" in the excel table. Then I want to import all the data under the field into my database (ms access).
May 20 '13 #1
2 1630
Stewart Ross
2,545 Recognized Expert Moderator Specialist
Access's External Data facilities allow you to import or to link the Excel worksheet as a whole. Once the worksheet is imported or linked - which the External Data wizards will take care of for you - you can use whatever queries you want to extract whatever is required from your field "name" or any other field in the worksheet.

-Stewart
May 20 '13 #2
mdtam
22 New Member
Sorry I want to do the importing data by using VB6. Not directly open my database.
May 20 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
5995
by: Katrina | last post by:
I am trying to write a piece of code that will search through a number of different tables (current one being tableNm) to look for a specific street name that has been entered by the user and saved...
1
8509
by: hemant123 | last post by:
Hi I am trying to insert null value in date field using vbasic textbox.I tried various options but failed.Please tell me the solution. Thanks in advance. Hemant
1
1458
by: jane2007 | last post by:
Hello, Here is my current code ... Dim rstStk As Recordset Set rstStk = CurrentDb.OpenRecordset("Select * from stk where PartNum = '" & strPrt & "'") The problem with this code is that i...
3
5147
by: sena0112 | last post by:
Hi, I'm a beginner in visual basic and programming. My programme needs to let the user browse for a text file and when the user press a command button, the programme will list out the text file into...
7
3301
by: jetaw03 | last post by:
guys, can you help me to get data from a text file and putting it in an excel file? my programming language is visual basic 6.0 here is a sample data from the text file: ...
3
1568
by: superfly | last post by:
Hi, I am new to visual basic and Ms Access but this is what I am trying to do. I have a Field called Act/Inact and in this field I have some records that say active and some records that say...
1
2877
by: chrspta | last post by:
I am new to Visual basic. I need a program using VB6 that converts txt files to excel file.Description is in the below: The form should have the Drive list, Dir list, file list and cmdConvert...
0
1083
by: sookfuny1984 | last post by:
In mysql, there is a query like select columnname, count(columnname) from tablename group by columnname If I wan to use Microsoft Access in Visual Basic 6.0 to do the same thing, how am I going...
0
1078
by: mchirouze | last post by:
Hi ! I'm trying build a tool that pre-processes an Access database and then exports the results to a SQL Server database. I find it easier to work with SQL queries than to do line-by-line...
0
1305
by: sudheerxplor | last post by:
how can i create a report in execel using vb6
0
7194
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7070
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7267
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
6976
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7449
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
4993
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4666
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
1
729
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
372
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.