Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

automate data converting (import) task from 2003 Excel to 2007 Access

Status
Not open for further replies.

wuju

Programmer
Oct 25, 2010
15
US
One of thing I want to do is to automate data converting (import) task from 2003 Excel to 2007 Access using visual basic.
There is an obstacle. Data in Excel are different format than I want to have in Access table, so can’t just use built-in importing step in Access.

What is the best way to automate conversion(import)of excel to access when they are two different format?
If you could address my problem, I appreciate it.

Regards,

Wu Ju

FYI. The following is the brief info for my data format in excel and access.

Excel:
Hour 1 Hr2 Hr 3 .................... Hr24
Date1: data1 data2 data3 ................. data24
Date2: data25 data26 data27 ................ data48
Date3: ................

Access:
Date Hour Data field
Date1 1 data1
Date1 2 data2
Date1 3 data3
..................
Date1 24 data24
Date2 1 data25
Date2 2 data26
..............
 
Use an UNION query to opulate your normalized access table.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top