Excel Row to Access Columns

M

mk389

Hi,

I have a single row in Excel with a lot of data, what I need to do is
move that to a column in Access. I need some way to automate that. I
know the easiest way to do that would to just transpose it in excel and
then import in access.But I cant do that as I just get that excel file
with one row and I need some way to automate the process in Access.

thanks
m
 
H

Harlan Grove

mk389 said:
I have a single row in Excel with a lot of data, what I need to do is
move that to a column in Access. I need some way to automate that. I
know the easiest way to do that would to just transpose it in excel
and then import in access.But I cant do that as I just get that excel
file with one row and I need some way to automate the process in
Access.
Click to expand...

If you need to do this in Access, ask your question in an Access newsgroup.

That said, there's NO WAY ACCESS CAN DO THIS without launching Excel to pull
data from XLS files. So, your choices are run Excel and transpose the data
in Excel or use VBA in Access to launch Excel via Automation and have
automated Excel transpose the data.
 
Top