Access 2013 doesn't support Dbase or does it?

Question

https://msdn.microsoft.com/en-us/library/office/ff192107.aspx

Is interesting in that it mentions you can use in the macro for ImportExportData Action.  Yet when I search the action catalog that Action is missing.  Is there some reason why it would be missing?

I know I could link to a DBase file via ODBC, but I don't have administrative privileges.

Answer 1

Not bad.  The DSum, DAvg, functions were life savers.    I still gotta figure out some error handling routines next week.   One involves a form, where once I delete records in a database to the last one, I notice if I select the #Deleted record, the Macro quits.   I used the Delete Record macro.    Is there any way to stop it from crashing on that?  The field is a list box of available values in a field.

The other thing I need is a macro to import a CSV into an existing table with the table headers defined but the directory is one the user using the macro willl have to select their own directory.  And it should check if the table is empty or not before inserting a new CSV.    Thank you.

Answer 2

Hi Abraham. Just wondering how you managed. Hope you got it to work. Cheers!

Answer 3

Thank you.  Will have to see how I can utilize the first one, one of the variables that has troubled me is that the filename is not always known.

Answer 4

Hmm, I'm not sure if this will help but Access 2013 does not include dBASE files in the Database Type options anymore. If you can use ODBC, then perhaps it's the only option. Just my 2 cents...

PS. I looked around, and here's a couple of threads with possible alternatives:

Use a Connection String

or

Use VBA code

Hope that helps...

Answer 5

It's there... while in the Macro Design View select *Show All Actions*