I have a problem with importing excel file into Access. I have some table in Excel and I want to import it into Access. When I d
o everything I have to do the data from some column (field) just disappears and then I have two tables in Access; for example Stationery and Stationery_import errors. Why it happens and how can I fix that problem???
2 answers:
You might be interested in
Hi, you haven't provided the programing language in which you need the code, I'll explain how to do it using Python, and you can follow the same logic to make a program in the programing language that you need.
Answer:
import math
def rectangle(perimeter, area):
l1_1 = (perimeter+math.sqrt((perimeter**2)-(16*area)))/4
l1_2 = (perimeter-math.sqrt((perimeter**2)-(16*area)))/4
l2_1 = area/l1_1
l2_2 = area/l1_2
print(l1_1,l2_1)
print(l1_2,l2_2)
if l1_1.is_integer() and l2_1.is_integer() and l1_1>0 and l2_1>0:
return(int(max(l1_1,l2_1)))
elif l1_2.is_integer() and l2_2.is_integer() and l1_2>0 and l2_2>0:
return(int(max(l1_2,l2_2)))
else:
return(None)
Explanation:
- We import math to make basic operations
- We define the rectangle function that receives perimeter and area
- We calculate one of the sides (l1_1) of the rectangle using the quadratic equation to solve 2h^2 - ph + 2a = 0
- We calculate the second root of the quadratic equation for the same side (l1_2)
- We calculate the second side of the rectangle using the first root on w = a/h
- We calculate the second side of the rectangle using the second root on w= a/h
- We verify that each component of the first result (l1_1, l2_1) is an integer (using the build-in method .is_integer) and greater than 0, if True we return the maximum value between them (using the max function) as w
- If the first pair of sides evaluate to False we check the second root of the equation and if they meet the specification we return the max value
- if all the if statements evaluate to false we return None to indicate that not positive or integer sides were found
The matchup are:
1) move to next cell in row - tab
2) move to previous cell in row - shift+tab
3) up one screen - page up
4) down one screen - page down
5) move to next worksheet - ctrl + page down
6) move to previous worksheet - ctrl + page up
7) go to first cell in data region - ctrl+ home
8) go to last cell in data region - ctrl + end
<h3>What are computer shortcut keys?</h3>A computer shortcut is known to be some group of one or a lot of keys that brings about a command in software or in any kind of operating system.
Hence, The matchup are:
1) move to next cell in row - tab
2) move to previous cell in row - shift+tab
3) up one screen - page up
4) down one screen - page down
5) move to next worksheet - ctrl + page down
6) move to previous worksheet - ctrl + page up
7) go to first cell in data region - ctrl+ home
8) go to last cell in data region - ctrl + end
Learn more about computer shortcut from
#SPJ1
