Transposing and importing from Excel

  • Thread starter Thread starter MarianneZ
  • Start date Start date
M

MarianneZ

I'm creating and programming a new database in Access 2007. I want to
get data from a set of existing Excel files, which are being
maintained and updated

The problem is the Excel files are transposed. The records are in
columns rather than rows. I know we can transpose the Excel file and
output to a txt file, which in turn can be imported into Access. But
I'd rather avoid this step if possible. Is there a way to import
directly and transpose "en route"? Or, better because it would be
always up to date, link directly to the Excel file and understand
what's there?

Marianne
 
Marianne,

This could be quite a complex operation, depending on how well your
spreadsheet files are organised. You will probably need to use
Automation code to import the data from Excel on a regular basis. The
only thing I can suggest is that you first have a look at Ken Snell's
Web site at :-
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#FilterExportSameFile
which has a lot of useful code for this.

You can always post a question to this News Group if you get stuck on
a specific problem.

Peter Hibbs.
 
Marianne,

This could be quite a complex operation, depending on how well your
spreadsheet files are organised. You will probably need to use
Automation code to import the data fromExcelon a regular basis. The
only thing I can suggest is that you first have a look at Ken Snell's
Web site at :-http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#FilterExportSameFile
which has a lot of useful code for this.

You can always post a question to this News Group if you get stuck on
a specific problem.

Peter Hibbs.
Click to expand...
Thanks, Peter, that's a useful web site.

Marianne
 
Back
Top