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

Need help Importing data from excel

23
I am trying to import data from a spreadsheet into a pre-created table. The table however has columns that the spreasheet does not such as an autonumber PK and an ID as the FK.

What is the best way to get start importing into column 3 of the table from the spreadsheet and keep the first 2 columns intact.

The other problem I have is when I try to import some calculated fields from excel I get #NUM! in the table.

Any help would be appreciated.
Nov 3 '06 #1
4 1587
NeoPa
32,554 Expert Mod 16PB
Your first question doesn't seem very clear, can you remember what it means?
As for the second, is the #NUM data already in the Exel spreadsheet? I suspect it is.
Tidy up your Excel data first then you could try 'Linking' the spreadsheet instead of importing it.
That way you could merge it in intelligently using an action query.
Nov 3 '06 #2
Fotorat
13
I think I know what you mean, to start importing from into the 3rd access tbl field you could simply insert to blank columns into the excel sheet so column A and B are blank.

the second problem you have in your formula cells in excel is that you are actually pasting in the formula text not the result of the formula. you can get around this in excel by highligthing the whole sheet and doing copy> paste special > values. warning> this will over write your formulas with the results, but will import ok

Tony
Nov 3 '06 #3
PEB
1,418 Expert 1GB
Ehe NeoPa you see... the sample Copy /Paste sometimes is more powerfull than the programming tools that we use ;)

Only Hide the columns that you don't ned to populate with info and the other will follow...

:)

And I think our language is sometimes a bit sofisticated for begginers...

But we think that everybody wants to do the things programatically :)

Best regards..
Nov 4 '06 #4
MMcCarthy
14,534 Expert Mod 8TB
I am trying to import data from a spreadsheet into a pre-created table. The table however has columns that the spreasheet does not such as an autonumber PK and an ID as the FK.

What is the best way to get start importing into column 3 of the table from the spreadsheet and keep the first 2 columns intact.

The other problem I have is when I try to import some calculated fields from excel I get #NUM! in the table.

Any help would be appreciated.
As NeoPa said, link the spreadsheet rather than importing it.

Now use an update query to add your data to the table if the records already exist (you will need some field value in common) or an append query to add new data to your table.
Nov 7 '06 #5

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

Similar topics

4
by: Little PussyCat | last post by:
Hello, I nee to write something that will transfer excel data into an SQL Server table. I have for another database application I wrote have it importing Excel spreadsheet data using cell by...
11
by: Grim Reaper | last post by:
I am importing a .csv file into Access that has 37 fields. My problem is that sometimes the last field only has data at the end of the column (it looks like when you import a file into Access, for...
9
by: Edward S | last post by:
I budget for a Project in an Excel sheet as illustrated below. The months below are usually a 2 year period i.e. 24 months, though it could be over 24 months depending upon a Project. I then...
7
by: Darren | last post by:
I have been attempting to create a reservation planning form in excel that imports Data from an Access database and inserts that information automaticly into the correct spreed sheet and the...
2
by: nutthatch | last post by:
I want to be able to import an Excel spreadsheet into Access 2K using the macro command Transferspreadsheet. However, the file I am importing (over which I have no control) contains some records...
1
by: Geoff Jones | last post by:
Hi I have a question which I hope somebody can answer. I have written a VB application with which I want to import an Excel file, analyze the data within it and do some calculations. There are...
2
by: Snozz | last post by:
The short of it: If you needed to import a CSV file of a certain structure on a regular basis(say 32 csv files, each to one a table in 32 databases), what would be your first instinct on how to...
2
by: jereviscious | last post by:
Hi all - Last resort time. I'm importing data from a spreadsheet that I receive from one of my vendor using interop.excel. The date field in excel is entered as 4/7/2006, but when I retrieve...
5
by: hharriel | last post by:
Hi, I am hoping someone can help me with an issue I am having with excel and ms access. I have collected data (which are in individual excel files) from 49 different school districts. All...
3
by: mukeshsrivastav | last post by:
dear sir i want to move form excel to access. i have 5 excel file having same formats and fields.now i want to import all data in one access table. importing one file is easy .but importing and...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
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: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
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)...

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.