Question of semantics: Import vs. Export?

[LNBruno]

I've seen the two words used almost interchangeably here and was just wondering:

Personally, I've been using the word "import" to describe bringing something from the source into the target:

usp_ImportExcelToSQLtable

and vice versa:

usp_ExportSQLtableToExcel

but I suspect this just my perception of the world revolving around SQL Server talking.

Any consensus out there?

< M!ke >

 

[mrdenny]

In your example cases you would be correct.

If you had a VB macro in a SQL Excel sheet that took data from the excel sheet and put it into SQL then you would be exporting from Excel and importing into SQL.

Use of the words import and export will depend on what side of the transfer you are looking at.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[LNBruno]

Yeah - makes sense.

Thanks for the sanity check mrdenny!

< M!ke >

 

[mrdenny]

no problem

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com