473,324 Members | 2,257 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,324 software developers and data experts.

Excel sheet in Access

Zerin
64
I have to develop a database in access and VB 2005 will be in front view. Some results are send to this software in .csv format and .jpg format and I have to store it in the database.Now, for .csv may be they'll use Excell sheet.........I'm not sure about it..........I'm new in this kind of arrangement.

Can anyone advice me about how can I read from an Excell Sheet and .jpg format files and store it in the database?
Dec 1 '06 #1
5 1758
NeoPa
32,556 Expert Mod 16PB
It rather depends on what you want to do with it (certainly the JPGs).
Access has facilities to import data from Excel (as well as to export to it).
In code you can use the DoCmd.TransferSpreadsheet() function, but it can be done manually too using 'Get External Data' from the File menu.
Dec 1 '06 #2
Zerin
64
Thanks NeoPa ,

Actually,first thing comes first.And that is.....how to read from an Excel sheet and store it into the table. I tried myself and also tried the net but no code isd working.

Can you help me please? You can send me links,too to look up for it.

Thanks again.

Zerin
Dec 4 '06 #3
NeoPa
32,556 Expert Mod 16PB
Go to the VBA window.
Hit Ctrl-G to go to the Immediate (Debug) pane.
Type in TransferSpreadsheet then hit F1.
This will open the context-sensitive help with the full explanation of the command. This is the one you need to import from Excel into an Access Table.
Dec 4 '06 #4
Zerin
64
Thanks once again.

May be I'll find out a solution.Can you tell me now........how to autoperge in VB 2005 Express? Can it be set as default as well as fetching frequency from the users? And can it be done by required free disk space (in term of %) ???

Looking forward for the ans.
Dec 5 '06 #5
NeoPa
32,556 Expert Mod 16PB
I'm afraid I can't tell you, but I can suggest that you post this question in the VB forum.
Someone there may well be able to help with that.
Dec 5 '06 #6

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

Similar topics

13
by: Allison Bailey | last post by:
Hi Folks, I'm a brand new Python programmer, so please point me in the right direction if this is not the best forum for this question.... I would like to open an existing MS Excel spreadsheet...
5
by: Rajiv | last post by:
HI ALL, actually , i m working in a company having large number of employee , i have two userid and password . on id is from admin group(id given to me by technology manager) of the server and...
1
by: Steven Stewart | last post by:
I have a user who has been using Excel for a while to keep statistics and print reports. She finds using it cumbersome because of long formulas and a lot of copying and pasting. I have designed...
3
by: Mads Petersen | last post by:
I'm stuck in this code. Hope you can and will help me. I launch it from excel. I have made the following code work, but not as i whant. I need the ranges to be working with something like xlDown....
13
by: Arno R | last post by:
Hi all, I will have to handle a lot of really 'nice' data in a LOT of Excel sheets. It is all about music files (Billboard top 100) I am afraid there really is a sheet for every year ... (Don't...
3
by: Conrad F | last post by:
Hello All, I know how to import a specific named excel sheet into a datagrid using ADO.NET by setting up a JET connection and then SELECTing data from the sheet. However, for a real world...
3
by: rlntemp-gng | last post by:
RE: Access 2003/Excel 2003 Problem: After I close the Access application completely, I go out to the Task Manager and there is an Excel.exe object still sitting out there. My Access...
0
by: Sajit | last post by:
I am trying to use an Excel file as a template for an Access report. I Linked the Excel file through an unbound frame as an OLE object with the properties set as follows: Source Doc...
0
by: DrewYK | last post by:
I have the project that may never end in front of me. I am creating a routine that will take SpreadSheets from Excel and bring them into Access. I am not using any "DoCmd"s because the goal...
7
by: kpresidente | last post by:
Hello all, I'm trying to transfer the value of a control on an Access form to an Excel worksheet using VBA. The Access form is a single form with all the controls disabled, so that data is "read...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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.