I am having data type problems.
The first thing I had to do was convert the weight of one column from kg to lb. I did this by multiplying by 2.20462262 and updating a new column, however, the column with the weight in kg was of the number data type but the new column with the weight in lb was of the text data type! It needs to be in number type, not text. Why is this and what can I do to change it?
I have also...
foxygrandma
Last Activity: Aug 13 '08, 08:29 PM
Joined: Jun 25 '08
Location:
-
Data type problem
When I import Excel sheets into Access the numbers are put into scientific notation format. For example:
I imported an Excel sheet with a "Delivery Number" column. For example: the number should come in as 40846268. It comes in as 4.08463e+007. Is there an easy way to fix this? -
I figured it out. Had to remove the primary key by deleting the ID columns. Worked like a charm after that. -
If I try:
INSERT INTO 1HSearchResults
SELECT [2HSearchResults].*
FROM 2HSearchResults ;
Then it throws a different error.
"Microsoft Access can't append all the records in the append query. It didn't add 49,576 record(s) to the table due to key violations. Do you want to add them anyway?"
I am trying to append around 51,000 records....Leave a comment:
-
INSERT INTO 1HSearchResults
SELECT [2HSearchResults].*
FROM 1HSearchResults , 2HSearchResults ;Leave a comment:
-
Append query
This is a pretty simple question I believe. I am just running into a small problem.
I imported two Excel sheets into Access. They have the same fields and field types and I simply want to combine them into one. Actually just attach the second one to the bottom of the first one. I imagine it's a simple append query to get the job done, but for some reason every time I try it runs for a couple minutes and then says "Ran out... -
From a table to a form to a table
A friend helped me develop in VBA a form that allows me to simply enter a shipment number and freight cost, and then it adds the calculated data to the main table. What it does is irrelevant.
What I have now is a table with two fields, shipment number and freight cost. It is basically a list of all of the shipment numbers with their freight costs that I have to enter into the form, which will in turn update the main table.
... -
This ought to put in...Code:Delivery# Shipment# GrossWeight Cost Month 81910252 565017 437.2 829.77 February 81910838 565017 2046 829.77 February 81910148 565017 3472.965 829.77 February 81910834 565017 899.193 829.77 February 81912056 565017 712.845 829.77 February 81910251 565017 609.12 829.77 February 81912054 565017 798.572 829.77 February 81911524 565017 2847.416 829.77 February
Leave a comment:
-
A little guidance?
I was assigned to fill in a column of costs in a 120,000 line table. Quite basically, I imported the data including the costs from excel into access (table 1), and used an update query to match the cost's position and update table 2 as necessary.
There were two types of data I was pulling from the table 1 and using to match position in the table, delivery numbers and shipment numbers. Every record provided only one number, either... -
I just kept trying things, and * worked. 1/*/2007 returned all January values.Leave a comment:
-
Date query question
Hi, I am trying to do a very simple select query based on date.
Basically, the Date column has dates in the format: MM/DD/YYYY. I need to search for one month at a time. The simplest way I figured to do it, (but have no clue how) is to make the criteria (for this example January 2007): 1/(some sort of function or place holder that can be any value)/2007. I do not know if this exists, or if I have to search by date range or what.... -
No need. I have figured it out. I created a relationship between the two fields and then ran an update query. It worked exactly as planned. Thank you for your help and patience.Leave a comment:
-
That is precisely what I'm trying to do. Step C may be omitted if it makes things easier. But the other steps are exactly what I'm trying to do....Leave a comment:
-
Can I get some guidance on doing this query? I simply need to pull values from one table and put them in another based on if two fields match. Being a beginner, I need some pretty basic instructions. I'm not sure how basic of a procedure this is though. Any advice would be appreciated. I can send you samples or screenshots if needed.Leave a comment:
-
I just copy and pasted it into a new excel sheet. Unless there is something wrong with this solution, I think that solves that problem....Leave a comment:
-
Thank you, I agree that this is a much more logical approach, however I have stumbled upon an issue with importing that seems to be a regular problem with Access.
When I try to import the Excel file, it throws an error "The Microsoft Jet database engine could not find the object "xyz." Make sure the object exists and that you spell its name and path correctly." What can I do to solve this?...Leave a comment:
-
Macro Possibility
I have been assigned a tedious, long project of manually taking data from Excel and inputting it into an Access table. It is not a difficult process, but it is time consuming and long and I believe it could be automated with a macro. The process is pretty simple.
In Excel, I go one line at a time, getting the shipment number.
I go into Access, search for that shipment number, and input the cost that corresponds to...
No activity results to display
Leave a comment: