Search results

Oh sorry Gina for confusion I meant "sheet1" table in the database "Armine" I have attached above. Please have a look only on Armine and Romania files attached in the same thread above. I dont know how to connect "Sheet1" and "Years" tables. Tnx

Hi, Before I had NAs in Excel and in order to replace it with something but not 0 (to know that i had a missing data there) i put -1. I dont know yet what totals am i going to need probably all kinds :) I just mentioned it to answer to your post. Now I am still trying to figure out how to...

Dear Gina I thought I gave a detailed explanation in the post below actually:( These are not totals but exactly number just for one good , out port of the country, one partner country , one direction from 2000-2012. For ex. in the file Romania Good named TT was imported (direction I), from...

Hi Sorry for crossport I am kind of in a panic nothing works out :confused: Gina, ya it is transportation so in the file Romania for example the columns represent certain criteria like the country it comes from where it goes etc. and then there is the amount of goods transported in 2000-2012...

Dear Gina I will try to explain it in details and see attached the partial sample files. The file Romania is one of the app. 20 countries I have data spreadsheets for which I need to import into excel, normalise create the relationships so I can use it afterwards. For all this spreadsheets the...

But i thought that a table MUST have a primary key ? Also do you know if I can connect 2 primary keys? pls see the dtb attached and advise how would you connect the tables Import and year? Also Partner and Import table relationship I thought that "Source_code " in Partner must be key and be...

Hi everyone I am importing data from excel and I want to put a primary key on a column but it doesnt let me saying "primary key cant contain a Null value", coz I have a "NO" or "O" value. But i dont understand why is it a problem as I have specified the field as text not number. Also is it...

Re: Importing from Excel and normalization Hi everyone I am back again Sorry previously for confusion I will try to explain it better and in details this time and see attached the partial sample files. The file Romania is one of the app. 20 countries I have data spreadsheets for which I need...

Yea also see attached one of the examples of the column criteria separate table , ex. Cargo column is coming from the separate table cargo with some other details. With this I think I know what to do but with the years and sales still cant imagine :((( Armine

Let me describe maybe the situation fully so u maybe could help me guys. So I have 25 countries with their own separate spreadsheets u can see 2 small examples in reality they r quiet big. So every column (Direction, Cargo..) has list of possible results which is the same for all this 25...

hi , Yea I will replace the NAs with smth, but this normalization is smth not understandable at all, for some example I look it is understandable coz they have small data but with this time series dont know what to do :((((Like when I was makeing a small database with limited thing and didnt...

Hi, tnx for feedback. Frankly, I am a beginner and not very much informed so sorry beforehand for stupid questions :) I attached the file, so I have approximately like this big time series in excel and I am importing it in Access (2007-2010) by "External data - Excel...". So I put the first part...

Hi everyone I am trying to import spreadsheets from Excel to Acces. So there are a lot of numbers that are missing and instead I have NA in excel. What can I do with this ? :confused: Tnx Armine