Importing data from Excel

[Anna22]

Dear all

I am trying to import a csv file which i get exported from an audit program which we use. the data contained in the csv file is network information. I have imported csv files into access many times before and never had a problem except with this file. The format of the csv is in columns rather than rows

example of a normal csv file
heading1,heading2,heading3
data1,data2,data3

example of my csv file
heading1,data1
heading2,data2
heading3,data3

Is there a way either by code or by an import routing to import the data column into my table

Any help would be greatly appreciated

Anna

 

[cghoga]

Check out the Transpose property in Excel.

Select the columns and rows and right click - choose Copy.
Then in another sheet right click - choose Paste Special and make
sure Transpose checkbox is checked.
Click OK.

You might be able to use VBA...

Range("A?:??").Select 'Fill in ?s with your ranges
Selection.Copy
Range("A1").Select 'New sheet
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True

Hope this helps.