Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 28th 04, 06:07 PM
Jac
 
Posts: n/a
Default Export Excel Data to Access With a Macro!!!

Hi,

I have been trying to create a macro in excel to automatically export data
into access, but to no avail. Would somebody please give me a hint?
Your assistance will be greatly appreciated.

Thanks

  #2   Report Post  
Old December 28th 04, 06:57 PM
vb_Sagacious
 
Posts: n/a
Default

Using Access either "Link" the spreadsheet as a table or import the excel data.
Otherwise research ADO and CreateTable to learn how to push the data cell by
cell.


Ken



"Jac" wrote:

Hi,

I have been trying to create a macro in excel to automatically export data
into access, but to no avail. Would somebody please give me a hint?
Your assistance will be greatly appreciated.

Thanks

  #3   Report Post  
Old December 28th 04, 07:23 PM
Jac
 
Posts: n/a
Default

What I am trying to do is to copy certain tab [spreadsheet] and Paste Append
onto Access. Therefore, neither importing nor linking will do it.

Thanks

"vb_Sagacious" wrote:

Using Access either "Link" the spreadsheet as a table or import the excel data.
Otherwise research ADO and CreateTable to learn how to push the data cell by
cell.


Ken



"Jac" wrote:

Hi,

I have been trying to create a macro in excel to automatically export data
into access, but to no avail. Would somebody please give me a hint?
Your assistance will be greatly appreciated.

Thanks

  #4   Report Post  
Old December 28th 04, 07:39 PM
vb_Sagacious
 
Posts: n/a
Default

Appending an entire "tab [spreadsheet]" would require that you use Access's
Import. However if you Link the specific "tab [spreadsheet]" you can use
queries to manipulate the data both ways, including in and out of an existing
table...

Nevertheless, you will want to create your spreadsheet (.xls File), save it
and then work from Access to pull the data. Otherwise, like I mentioned you
could push the data using ADO, but this is much more difficult and would
require more than just simple macro knowledge.

Hope this helps,
Ken


"Jac" wrote:

What I am trying to do is to copy certain tab [spreadsheet] and Paste Append
onto Access. Therefore, neither importing nor linking will do it.

Thanks

"vb_Sagacious" wrote:

Using Access either "Link" the spreadsheet as a table or import the excel data.
Otherwise research ADO and CreateTable to learn how to push the data cell by
cell.


Ken



"Jac" wrote:

Hi,

I have been trying to create a macro in excel to automatically export data
into access, but to no avail. Would somebody please give me a hint?
Your assistance will be greatly appreciated.

Thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I export Excel data into another software? JZ Excel Discussion (Misc queries) 0 December 24th 04 01:15 PM
Refreshing Access data in Excel Jimmy G Excel Discussion (Misc queries) 0 December 21st 04 03:53 PM
populating data from excel into access Chris Links and Linking in Excel 1 December 15th 04 07:50 AM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM
Data population between excel and access - Errors on missed fields Chris Excel Discussion (Misc queries) 0 December 13th 04 11:55 AM


All times are GMT +1. The time now is 06:17 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017