Transposing and importing from Excel

[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

 

[Peter Hibbs]

Marianne,

If this is a one-off operation then you could have a look at the Excel
to Access Converter Utility at :-
http://www.rogersaccesslibrary.com/...?TID=183&SID=e81a164e2314187z3e8587231e28cb7d

Peter Hibbs.

 

[MarianneZ]

Marianne,

If this is a one-off operation then you could have a look at theExcel
to Access Converter Utility at :-http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=183&SID=...

Peter Hibbs.





- Show quoted text -

Well, alas, this is not a one-time operation. Multiple Excel files
with ongoing updates.

Any other suggestions?

 

[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 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.

 

[MarianneZ]

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.

Thanks, Peter, that's a useful web site.

Marianne