473,320 Members | 1,817 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,320 software developers and data experts.

Excel to Access Conversion

AJ
Hi,

I have been trying to convert an excel spreadsheet to an access
database for a while now...and I'm at the point where I'm pulling out
my hair. I've looked high, and low, and I've pulled out all but 2
strands of hair on my head, and 1/2 my eyebrows are gone.

Can someone PLEASE help me out? I'm totally at wits end.

Help me oh great access guru's!!

Thanks,

AJ
Nov 13 '05 #1
2 2421
"AJ" <mr*******@yahoo.com> wrote in message
news:42**************************@posting.google.c om...
Hi,

I have been trying to convert an excel spreadsheet to an access
database for a while now...and I'm at the point where I'm pulling out
my hair. I've looked high, and low, and I've pulled out all but 2
strands of hair on my head, and 1/2 my eyebrows are gone.

Can someone PLEASE help me out? I'm totally at wits end.

Help me oh great access guru's!!

Thanks,

AJ


From Access:
File => Get External Data => Import...

in dialog box:
File of Type: Microsoft Excel (*.xls)
File Name: Your XLS file

Follows Import Spreadsheet Wizard.

If you mean how to import via VBA, then
let me know.

Ciao
Bruno
Nov 13 '05 #2
AJ wrote:
Can someone PLEASE help me out? I'm totally at wits end.


Not really, unless you provide more information like what it is you're
doing in Excel, are you using VBA/macros, what sort of data are you
tracking? To draw an analogy, your question is like someone with a
malfunctioning car who simply cries out "help me fix it!" without
describing what weird noises or behaviour is happening! 8) 8)
--
Tim
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

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: George | last post by:
Sub ExcelToListBox() Dim xRange As Object Dim ary Dim xValue As String xRange = oXL.Range("A1:A9") 'has letters A-H ary = xRange.value xValue = ary(3, 1) 'xValue = C...
1
by: BrianDH | last post by:
Hi We have a Vb.Net Windows application that’s about a year old. The application takes data from our SQL DB and creates an excel SS and emails them to customers. However, we now have PCs in...
6
by: james.igoe | last post by:
I've been hired to produce a reporting database that takes data from numerous sources (5 financial products, from three regions, each with multiple tabs) and although I'm confident I can build...
4
by: smugcool | last post by:
HI, I am trying to import an excel data. All the fields are geting imported properly. But i am geting error in the date field. I tried to keep the format both in excel and access very similar.But...
1
by: elbatz | last post by:
Hello.Does anyone here know how to convert or export data from excel to access database having an existing table using visual basic 6 codes? And if that data in excel already exist in access...
0
by: cht13er | last post by:
Good day all, I'm a newish VBA coder who was taught from Google Groups - so thanks to you all very much! I have run into a minor problem, I hope you can give me some help ... I'm running office...
7
by: CSharpCoder | last post by:
I have an Excel VBA app that has 25 forms within and is reading from 60 Excel Sheets for a datasource. This needs to be converted over to the web in 10 days, and it took almost 3 months to do the...
2
by: mkbrady | last post by:
I have a query that includes calculated fields that generate numeric results. I have wrapped conversion functions CLng() and CDdl() around the calculated fields to ensure the data types are...
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...
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: 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
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.