Hi all,
I need to create a .mdb access file from excel file which have informations about field name, width and type datal. Could you tell me how to make it from FME workbench?
This is my excel data (input). I want to make 4 columns in .mdb with type, width data the same here.
Hi @hoa_le, if you want to create a *.mdb file that contains an empty table with the fixed four fields, a possible way is:
The workflow on the Canvas looks like this.
Hi Takashi,
If my excel file have 200 field name which I want to create. I can't make manual, so could you tell me how to way to import excel file description for each field to .mdb by automatically?
Thank you
You can create an attribute storing a SQL CREATE TABLE statement based on the field definitions read from the Excel table, and then execute the statement with a SQLExecutor. Just be aware that the dataset (i.e. *.mdb file) must exist when executing the SQL statement to create a table.
A basic CREATE TABLE statement looks like this.
create table new_table (
name char(12),
ages integer,
province char(30),
Mark integer
);You can create an attribute storing a SQL CREATE TABLE statement based on the field definitions read from the Excel table, and then execute the statement with a SQLExecutor. Just be aware that the dataset (i.e. *.mdb file) must exist when executing the SQL statement to create a table.
A basic CREATE TABLE statement looks like this.
create table new_table (
name char(12),
ages integer,
province char(30),
Mark integer
);
Thank you so much Takashi.
In FME has not exist double, float type? Can change the same type double, float by?
Thank you so much Takashi.
In FME has not exist double, float type? Can change the same type double, float by?
https://support.office.com/en-us/article/SQL-Data-Types-9188f41d-6c0e-4733-9d20-d08916f50bd2
Note: char(n) is an alias of text(n).
Basically FME can map every native data type of all supported database formats to FME generic data type.
Thank you Takashi. If String type, I see that replace by char. But with Float and double type. What type will be replace?
Thank you Takashi. If String type, I see that replace by char. But with Float and double type. What type will be replace?
See again the list of Access SQL data types I've linked previously.
https://support.office.com/en-us/article/SQL-Data-Types-9188f41d-6c0e-4733-9d20-d08916f50bd2
You can see these two types for floating point number.
Thank you Takashi. If String type, I see that replace by char. But with Float and double type. What type will be replace?
Thank you Takashi. If String type, I see that replace by char. But with Float and double type. What type will be replace?
Thank you so much. I will use number type
