convert Excel data to Access

J

JMLCORP

Does anyone know how to convert excel spread sheet into
Access? the excel file have mulitple spread sheet. I am using the
marco to pick up the data from the sheet1 then output to sheet2, and
then calcurate the result to output to sheet3. How can I import those
data to access? I tried to use import data from external data in
Access, but it doesn't work. Any suggestions? Thanks
 
G

Guest

You can create a "linked" table in Access linked to the spreadsheet. Then
create an "append" query that will take the data from the linked table and
place it in the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
EXCEL - IF(IFERROR(VLOOKUP question 0
SHEE1. Duplicate all sheets, making 2 copies of ea. / 2. Add " E"and " F" to end of tab name. / 3. 3
Getting information from access table in excel 1
Excel Macro for match name 5
VBA Code for Pasting Sheets 2
Importing Data from Access to An Excel Sheet 5
sheet formulas and strings 1

Top