473,327 Members | 2,007 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Appending set of data from excel to access?

Dear all,
I want to append some list of values from excel sheet to Access table.In excel sheet, column A i have 5 values like given below.

Column A

101010
101020
101030
101040
101050.

In access i have one table named empmaster, in that i have one field empid.In empid field already i have 10 records(no duplicate values).Now i want to copy the above mentioned 5 values from excel and need to paste or append in empid field. I have 100s or records to add like this.If anybody gives the solution will be gratefull to me.help me.

Regards,
Gemini
Mar 21 '12 #1
2 1136
MikeTheBike
639 Expert 512MB
Hi

This is not too difficult to do this in access with automation, provided that the sheet/range where the data ais in the spreadsheet is defined and consistand. But I have a question or two first.

1) Please expand on 'I have 100s or records to add like this'. ie. hundres of files/sheets/columns ??

2) I assume empid is a long integer and not autonumber.

3) Where is the related data (I assume there is some ie, employee name or whatever)?.


MTB
Mar 22 '12 #2
Mihail
759 512MB
Here
http://bytes.com/topic/access/answer...el#post3711321
I think you will find what you are looking for in post #16
Mar 22 '12 #3

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

Similar topics

2
by: ASIF | last post by:
Does anyone klnow of a quick way of exporting data from access to a text doucument, the data needs to be tab seperated, and the data to be exported needs to be selected using parameter queries. I...
0
by: lewang | last post by:
I am trying to get data from Access through a SQL query from Excel via VBA: but i get an error of "Run Time Error '-2147467259 (800040005)': Method 'Open' of object '_Recordset' failed" I have...
1
by: oasd | last post by:
I'm having difficulty appending data. I have an import macro (using the Transferspreadsheet function) to import data from an excel spreadsheet (located in a USB attached to the pc) to an access...
1
by: gssstuff | last post by:
Hi I have a need to send data from Access to an existing Excel template that I am using for reporting purposes. The nature of the data in the Access data table does not lend itself to a simple...
20
by: TC | last post by:
I need an automated procedure to copy data from an Access table to a SQL Server table. Speed is important. What is the recommended technique? I can export the data from Access, copy it via FTP,...
1
by: Mohsin | last post by:
Hi, any one can help me to save visual Basic Data in Access to link through Data control or ODBC. when i am trying to save vb data in Access after making link through data control it is not saving...
4
by: sharper | last post by:
Hi to all ! I have problem with C# and access databasses! I can't to insert new record in database , ( I mean I made grid view and connect him with a access database and made all things to...
0
by: =?Utf-8?B?QkFUT04=?= | last post by:
I have realy big problem I try lot of things but never success! I need a HELP! Problem is in that I made database in Microsoft access and connect her to C# form and datagridview. and it...
1
by: yogeshbhardwaj | last post by:
I have an excel sheet. its format is like a group eport in access example given below: Soap Sr. no. Qty. Amount 1 15 150 2 ...
0
by: TrevoriousD | last post by:
hi I have created a data link from access query to excel. I use excel pull data from access in order to do stats. the excel workbook always stays in the same folder as the access db. I want to be...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.