How to import data from excel sheet using SqlAssistant

Tools
Enthusiast

How to import data from excel sheet using SqlAssistant

Hi,

I need to import rows from an excel sheet to a table in my data base using SQLAssistnt.

DDL of my table

CREATE MULTISET TABLE ANIL.XREF ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
METRC_ID SMALLINT NOT NULL,
TRAN_TYPE SMALLINT NOT NULL,
INCR_DECR CHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL)
UNIQUE PRIMARY INDEX XREF_UPI ( METRC_ID ,TRAN_TYPE );

Thanks in Advance.

Regards,

Anil
7 REPLIES
Enthusiast

Re: How to import data from excel sheet using SqlAssistant

Hi Anil,

There are several ways to inport the data from Excel sheet to our target database. I will tel you one of two approach, you can try any of that.

Follow the steps :-
-------------------
I) Approach I
-------------
1. Export data File from Excel to Comma Separated values (CSV ) Format.
2. Use Fastload For your Database Table
3. Now make use of the generated CSV files
4. point to file generated & Run the Fast Load Scripts

II) Approach II
-------------
1) Apply Formula Logic in Excel Sheet & try to generate the Individual Insert Select Statement
2) once if you gets it , You can execute all the scripts in SQL Assitance.

Let me know if you have any other issues.

Enthusiast

Re: How to import data from excel sheet using SqlAssistant


Junior Member

Group: Forum Members
Last Login: Today @ 9:41:19 PM
Posts: 22, Visits: 65
hi

-------------------
I) Approach I
-------------
1. Export data File from Excel to Comma Separated values (CSV ) Format.
2. Use Fastload For your Database Table
3. Now make use of the generated CSV files
4. point to file generated & Run the Fast Load Scripts

tell me how 2 convert excel file into CSV file format?

Enthusiast

Re: How to import data from excel sheet using SqlAssistant

There are two ways to do that

1) Go to Excel Worksheet where you want to convert into CSV
2) Save the Doc as CSV file Format ( .CSV )
3) then Finally Open the doc in Notepad
4) Now you can able to see the data in delimited format

Enthusiast

Re: How to import data from excel sheet using SqlAssistant

Maran,

Thanks for your responce,

There is an option to import data from file in SQL Assitant,but I am unable to undertand how to use
that option.

GO to tools->options->export/import/->import

and then goto FILE->import data.

please let me know if you have any idea about this.

Regards,
Anil
Enthusiast

Re: How to import data from excel sheet using SqlAssistant

Click on File and Select Import Data,

Now write

insert into table.name
values
(?, ?, ?, ?) no of columns on the table should be equal to ?

now press f5, it will ask for the source, jus browse and select the source and you can load the data in to the table using SQL assistant.
Enthusiast

Re: How to import data from excel sheet using SqlAssistant

And when your data is loaded, agagin goto file and click on import data.
Enthusiast

Re: How to import data from excel sheet using SqlAssistant

SQL assistance will support only a delimited text file , Unicode text file ,UTF-8 text file and MS Access table only. Other file types r not suppported by SQL assistance.

cheers.