Hi,

Lines this Null in column 001 will not be imported.

Try this transformation script :

'  Visual Basic Transformation Script

'************************************************************************

Function Main()

 If   IsNull(DTSSource("Col001"))  = True  then 

 Main = DTSTransformStat_SkipRow

 else

 DTSDestination("Col001") = DTSSource("Col001")

 DTSDestination("Col002") = DTSSource("Col002")

 DTSDestination("Col003") =...

Hi,

Why not set the properties in Text File Properties to:

File type ANSI

Row delimeter CRLF

Column delimeter to TAB

Text qualifier none

Hi,

This topic has been on the agenda before. I recommend that you first (in the VBA macro) save each sheet as a text file and then use DTS to import...

What do you have in column1 ?

The default datafiletype for bulkinsert is char.

Maybe

WITH ( ROWTERMINATOR = '|\n',DATAFILETYPE='widechar',

CODEPAGE='ACP')

will solve the problem.

/gosta

Dear Phil,

It should be possible to accomplish what you describe but your description is to vague for an "exact" advise.

I have made many applications where a database like SQL-server and Excel "share" data....

Randy,

My example is originally written in VB6 so there is a

Set appExcel = CreateObject("Excel.Application")

so the answer is yes.

But it should be possible to write it as an

 Visual Basic...

Randy,

I had the same situation and started to use a complicated procedure paste special etc etc. After some thought I found a much more efficient and faster method.

Part of the...

Hi,

This topic has been on the agenda before in this forum. I had the same problem. If numbers and text in a column alters between the rows the...

I agree most people use Excel as "front end" and the crucial thing is to export to Excel and then import from Excel to a database like Access. Many...

Sorry continues.

ID Column property

1   1        something

1   2        something

etc

2   1       etc

2   2       etc

2   3       etc

And import each individual excelsheet to this table....

What you describe is a typical situation having a product with different number of properties. You don't tell if you are using DTS  VB ADO etc. But what you...

Hi. Why use AxtiveX Script for this task. VB or VBA is easier.

This will also work added to what Stephen wrote:

'**********************************************************************

'  Visual Basic ActiveX Script

'************************************************************************

Function Main()

Set...

Interesting. I tried that solution but it didn't work for mee.

I have the same type of problem linking an Excelsheet to Access. (Office 2003)

If there are numbers or text in a column and the format is text some rows are not...

Having about the same situation as described I just save the values of the global variables in a table (in this case one column).

I created an Execute SQL Task for...