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

Importing excel file into Access using Macro

P: 1
I am able to import a file from excel to access manually, using the top row as my headings, successfully. however, when using the TransferSpreadsheet command in a macro, importing, excel 5-7, has field names is YES, the file comes thru with all the alpha heading correct but the last few are years, 1998, 1999 etc and they come thru as F8, F9 etc. (however they come thru fine when I import manually)

HELP!
Aug 22 '07 #1
Share this Question
Share on Google+
1 Reply


pbmods
Expert 5K+
P: 5,821
Heya, Christie. Welcome to TSDN!

I'm going to go ahead and move this thread to the Access forum, where our resident Experts will be better able to help you out.
Aug 22 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.