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

Importing excel spreadsheets without defining table

P: 24
Hi All,

This seems like a simple thing, but I canít seem to figure it out. I am familiar with transferring excel spreadsheets into access using the TransferSpreasheet function Ex:(DoCmd.TransferSpreadsheet acImport, 8, "LogTemplate", "C:\Documents and Settings\My Documents\Log template.xls", True, "").

I would like to import several spreadsheets into access without creating the table. I know how to manually import the spreadsheet but how can it be done without assigning a table. I would to import the spreadsheet and then the table created, just like if I was to do it manually. I tried removing the table from the example I have above but I get an error. I know this is probably simple but canít figure it out. Thanks for any advice.
Jan 15 '08 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,276
Please take more care with your question Umoja. You seem to be saying that you want to import data into Access but not store it in a table which doesn't make sense.

What exactly ARE you trying to say?
Jan 15 '08 #2

P: 24
Hi NeoPa,

Sorry my question wasn't clear. I figured out what I was doing wrong. I needed to take a break to clear my head. Thanks for replying back.
Jan 15 '08 #3

NeoPa
Expert Mod 15k+
P: 31,276
:D
Sometimes that's all it takes. I'm glad you got it sorted anyway.
Jan 15 '08 #4

Post your reply

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