I want all data to be stayed

Jogreen

New member
Local time
Today, 03:49
Joined
Aug 17, 2017
Messages
1
Hi, I'm new to Ms Access

I installed MS Acecess 2010.
I externaled data from one excel file, but on the way table analyzer wizard
is going, I found the wizard modifing my data automatically.
I needed to every row to be stay on but I wanted it all data.
What can I do? I need somebody help :banghead:
 
Create a primary key or index with no duplicate on your field. Use update query then.
 
The wizard will decide the data type of the Access imported table field based on the type of values in the first few cells of the Excel column.

So it you have values that look like numbers in the first few rows of a column, the imported field will be a number type. Then if you have text further down, these text values will be rejected.

Ensure the top rows of any Excel columns that contain text have values that cannot be interpreted as numbers.
 

Users who are viewing this thread

Back
Top Bottom