1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
cluponka [151]
3 years ago
6

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???​

Computers and Technology
2 answers:
olasank [31]3 years ago
7 0

As the poster mentioned in the comments, one data field had the wrong data code (integer instead of long integer). When the data is imported to Access, there is a data mis-match; causing the import error. The poster did a good job in identifying the cause.

Vlada [557]3 years ago
4 0

need 2 describe exactly how u did the import when u had trouble.

my suggestion is to export from excel as txt or csv file format 1st; then import the txt or csv file to Access

You might be interested in
Use the arr field and mystery () method below.
kolezko [41]

Answer:

The sum of all positive even values in arr

Explanation:

We have an array named arr holding int values

Inside the method mystery:

Two variables s1 and s2 are initialized as 0

A for loop is created iterating through the arr array. Inside the loop:

num is set to the ith position of the arr (num will hold the each value in arr)

Then, we have an if statement that checks if num is greater than 0 (if it is positive number) and if num mod 2 is equal to 0 (if it is an even number). If these conditions are satisfied, num will be added to the s1 (cumulative sum). If num is less than 0 (if it is a negative number), num will be added to the s2 (cumulative sum).

When the loop is done, the value of s1 and s2 is printed.

As you can see, s1 holds the sum of positive even values in the arr

7 0
2 years ago
Router 1 is configured with static NAT. Addressing on the router and the web server are correctly configured, but there is no co
marin [14]

Answer:

The router NAT configuration has an incorrect inside local address.

Explanation:

The term Inside in a <em>Network Address Translation (NAT) </em>context refers to networks owned by an organisation that must be translated. When NAT is configured, hosts within this network have addresses in one space (known as the local address space). These hosts appear to those users outside the network as being in another space (known as the global address space).

The term Outside refers to those networks to which the stub network connects, and which are not under the control of an organisation. Also, hosts in outside networks can be subject to translation, and can thus have local and global addresses

7 0
2 years ago
Consider tree from the lectures on slide 10, write down the nodes in order as pro-
Leto [7]
The work same to be level order traverse and the sea is completely
7 0
3 years ago
My cell phone rear camera is dirty does anyone know how to clean it?
Vesna [10]
If you have glasses the liquid and cloth can be used to clean it. You spray the camera, then use the cloth to wipe it up. If you don't have them the dollar store should have some, or even places like Walmart and Maceys.
5 0
2 years ago
Read 2 more answers
Because collecting the adjustment data requires time, the adjusting entries are often a.estimated and recorded earlier than the
Yanka [14]

Answer:

b. entered later but dated as of the last day of the period.

Explanation:

Because collecting the adjustment data requires time, the adjusting entries are often entered later but dated as of the last day of the period.

6 0
3 years ago
Read 2 more answers
Other questions:
  • What do students buy when they pay tuition?
    6·2 answers
  • 4
    10·1 answer
  • Playstation network live updates pes 2018 does it cost extra
    13·1 answer
  • Access Control can be defined as putting controls (or countermeasures) in place to help achieve information security goals. Whic
    13·2 answers
  • True/False: Audio menus can be useful when one's hands and eyes are busy, or to assist vision-impaired users. With audio menus,
    14·1 answer
  • The velocity dimension of Big Data refers to _____.
    15·1 answer
  • Strobe lights can become more yellow as they age true or false
    8·1 answer
  • Write a method so that the main() code below can be replaced by simpler code that calls method calcMilesTraveled(). Original mai
    11·1 answer
  • How do you invite someone to a conversation on brainly
    14·1 answer
  • س2) اکتب خوارزميه لحل المعادلة الرياضيه الاتيه
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!