Access 2007 error 3270 when trying to save import of data from Excel

skagariseecasd
skagariseecasd used Ask the Experts™
on
Hi:
I have attached a pdf file with the access problem that i'm having.
Thanks
Steve Access-Problem.pdf
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi,

I found a link on the internet that says that it is isn't a option in Office 2007

see: http://www.pcreview.co.uk/forums/thread-3635675.php

Author

Commented:
Hi:
I'm trying to pull data into Access from Excel.
Thanks
Steve
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
First things first.

What happens if you make the Field names exactly the same in the spreadsheet and the Table (Using the Underscore characters in the field names)?

Also, as a side note, please try to post image files (.jpg), instead of PDF's.
Image files can be viewed here directly in the thread.
Posting a PDF forces the PDF reader to open on our local machines.
;-)

JeffCoachman
MIS Liason
Most Valuable Expert 2012
Commented:
monstermark,

Hello.
:-)

<I found a link on the internet that says that it is isn't a option in Office 2007
see: http://www.pcreview.co.uk/forums/thread-3635675.php>

Yes, this was the case a while ago, but this functionality was restored in a subsequent Service Pack or Hotfix.

In any event, if the SP2 is installed, the Import should work fine.

;-)

JeffCoachman
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
;-)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial