[AccessD] Importing XLSX

[Jim Dettman]

 None.  You have two basic options:

1. An ad-hoc utility run with task manager to do a .xlsx to .xls conversion.

2. Have whoever is supplying the data give it to you in .csv format.

Jim. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Rocky Smolin
Sent: Wednesday, May 04, 2016 11:31 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Importing XLSX

Dear List:
 
I'm still using 2003 for development - should probably up to 2010.
However...
 
I have an app which requires processing data from XL spreadsheets.  My usual
method is to use TransferSpreadsheet into a front end table and process the
records from there.
 
However, TransferSpreadsheet doesn't seem to like xlsx format. If I save the
file as xls, no problem.
 
Is there a way to use TransferSpreadsheet on an xlsx file in A2003?
 
MTIA
 
Rocky Smolin
Beach Access Software
760-683-5777
www.bchacc.com <http://www.bchacc.com/> 
www.e-z-mrp.com <http://www.e-z-mrp.com/> 
Skype: rocky.smolin
 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com