By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,345 Members | 1,667 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,345 IT Pros & Developers. It's quick & easy.

Is it possible to

P: n/a
Is it possible to import information from excel into access if the info in
excel is in a vertical format.

What I mean is Collum "A" has the following
* Company
* Contact
* Position
* Address

This info is repeated for 1425 rows.

Collum "B" has the actual information.

If this makes sense to anyone, can you help?

Thanks, Scott
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Have you even tried the Import wizard? Make a backup of your Excel file,
then try it out. It will walk you through importing from Excel and ask you
how the information is arranged. Follow the prompts and you should be
successful, even if it takes 2-3 tries.
-Ed

"Scott" <sc********@iinet.net> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
Is it possible to import information from excel into access if the info in
excel is in a vertical format.

What I mean is Collum "A" has the following
* Company
* Contact
* Position
* Address

This info is repeated for 1425 rows.

Collum "B" has the actual information.

If this makes sense to anyone, can you help?

Thanks, Scott

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.